> From: pgsql-performance-owner@xxxxxxxxxxxxxx > [mailto:pgsql-performance-owner@xxxxxxxxxxxxxx] On Behalf Of > vincent.moreau@xxxxxxxxxxxxxx > Subject: Re: [PERFORM] Execution plan changed after upgrade > from 7.3.9 to 8.2.3 > > > Increasing the default_statistics_target to 1000 did not help. > It just make the vacuum full analyze to take longer to complete. Just FYI when you change statistics you only need to run ANALYZE, not VACUUM ANALYZE, and definetly not VACUUM FULL ANALYZE. I don't know what else to suggest for this query since you can't change the SQL. I would talk to the vendor and ask them to add indexes if you know that helps. Dave
