aboutsummaryrefslogblamecommitdiffstats
path: root/nominatim/postgresql.conf
blob: d5a30b93b8adb5db10673c90b1cc39ac049ef7f9 (plain) (tree)
1
2
3
4
5
6
7
8
9
10
11
12
13
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