For starters,


------------------------------------------------------------------------

shared_buffers = 110592
wal_buffers = 400
sort_mem = 30720
vacuum_mem = 10240
checkpoint_segments = 30
commit_delay = 5000
commit_siblings = 100
effective_cache_size = 201413

Try more like this:

shared_buffers = 30000
wal_buffers = <default>
sort_mem = 4096
vacuum_mem = 10240
checkpoint_segments = 30
commit_delay = <default>
commit_siblings = <default>
effective_cache_size = 100000

Chris


---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

Reply via email to