Postgresql Performance Tuning

Run time configuration

  • default_statistics_target

increasing this value from default (10) for a large table seems to produce a better query plan. This value is used by the ANALYZE to collect some statistics from your table so the planner would be able to define what plan to use.

 
pgsql/tuning.txt · Last modified: 2007/10/31 01:08