... > #effective_cache_size = 1000 # typically 8KB each That's horribly wrong. It's telling PG that your OS is only likely to cache 8MB of the DB in RAM. If you've got 1GB of memory it should be between 64000 and 96000
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
