Writing /home/k4ml/webapps/drupal5/wiki/data/cache/d/db696dfd27a0f88f562e360ca9a7105f.i failed
Writing /home/k4ml/webapps/drupal5/wiki/data/cache/d/db696dfd27a0f88f562e360ca9a7105f.i failed
Writing /home/k4ml/webapps/drupal5/wiki/data/cache/d/db696dfd27a0f88f562e360ca9a7105f.xhtml failed

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