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> -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
