diff options
| author | U-ES\sadeghi.f <thabogre@gmail.com> | 2020-11-15 14:56:49 +0000 |
|---|---|---|
| committer | U-ES\sadeghi.f <thabogre@gmail.com> | 2020-11-15 14:56:49 +0000 |
| commit | ce04eac2bcf2bed97677e6601d7f8d9a7b0714dc (patch) | |
| tree | c459682cd4a80f22678c4212b5d7516b140bd000 /nominatim/postgresql.conf | |
| parent | update (diff) | |
| download | dockerimages-ce04eac2bcf2bed97677e6601d7f8d9a7b0714dc.tar.gz dockerimages-ce04eac2bcf2bed97677e6601d7f8d9a7b0714dc.zip | |
update
Diffstat (limited to 'nominatim/postgresql.conf')
| -rw-r--r-- | nominatim/postgresql.conf | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/nominatim/postgresql.conf b/nominatim/postgresql.conf new file mode 100644 index 0000000..d5a30b9 --- /dev/null +++ b/nominatim/postgresql.conf @@ -0,0 +1,14 @@ +shared_buffers = 1GB +maintenance_work_mem = 4GB +autovacuum_work_mem = 1GB +work_mem = 50MB +effective_cache_size = 4GB +synchronous_commit = off +checkpoint_segments = 100 # only for postgresql <= 9.4 +max_wal_size = 500MB # postgresql > 9.4 +checkpoint_timeout = 20min +checkpoint_completion_target = 0.9 +autovacuum_max_workers = 2 +# reenable after initial import +fsync = off +full_page_writes = off |