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 |