On Fri, June 3, 2011 13:57, tv(at)fuzzy(dot)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>