From ce04eac2bcf2bed97677e6601d7f8d9a7b0714dc Mon Sep 17 00:00:00 2001 From: "U-ES\\sadeghi.f" Date: Sun, 15 Nov 2020 18:26:49 +0330 Subject: update --- nominatim/postgresql.conf | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 nominatim/postgresql.conf (limited to 'nominatim/postgresql.conf') 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 -- cgit v1.2.3