On Fri, June 3, 2011 13:57, t...@fuzzy.cz 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> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
