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
