Optimizing Postgresql
Rene discovered nice options in postgresql.conf
- Planner Method Enabling -
enable_hashagg = true
enable_hashjoin = true
enable_indexscan = true
enable_mergejoin = true
enable_nestloop = true
enable_seqscan = true
enable_seqscan = false
enable_sort = true
enable_tidscan = true
For example disabling enable_seqscan seems to help a lot in some cases, as it in most cases uses the indices. It does not seem to be a panacea though.
More importantly, these options can be easily specified using SET command, e.g.
SET enable_seqscan to off;