diff options
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 |