> On Fri, June 3, 2011 13:57, tv@xxxxxxxx wrote: >> There's something very wrong with snames - the planner expects 22 rows >> but >> gets 164147851. Which probably causes a bad plan choice or something >> like that. >> Try to analyze the snames table (and maybe increase the statistics >> target on the columns). > > ANALYZE is your friend indeed, like a nice cold beer... from over 500k ms > to > 1 ms. > > I was running ANALYZE on one of the tables in the join, but not the > others... > <sigh> So you have turned off autovacuum (that should handle this automatically) or you're running an old version (autovacuum was enabled by default in 8.3 IIRC). regards Tomas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
