Harry Rossignol <harry...@comcast.net> wrote: > I'm just a lowly end user. Bumping the default statistics target > or using ALTER TABLE SET STATISTICS has made large differences in > query performance on large tables. The default has been bumped up in later versions, so that shouldn't be as big a problem as it once was. In this particular case the EXPLAIN ANALYZE showed the estimated row counts were quite accurate compared to the actual, so this definitely wasn't the problem this time. -Kevin
-- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
