On 07/21/2012 06:19 AM, Ioannis Anagnostopoulos wrote:
On this Ubuntu installation the default_statistics_target = 1000 and
not 100. Do you think that this might be an issue?
Nope. You should generally avoid setting default_statistics_target too
high anyway; leave it where it is and use ALTER TABLE ... ALTER COLUMN
... SET STATISTICS to raise the targets on columns where you're seeing
bad statistics estimates.
http://www.postgresql.org/docs/9.1/static/sql-altertable.html
Also make sure autovaccum is running frequently so it keeps the stats up
to date.
--
Craig Ringer
