> On Fri, June 3, 2011 13:57, tv@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>
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