Jon Lapham <lapham(at)extracta(dot)com(dot)br> writes:
>> Uh, have you VACUUM ANALYZEd yet? Those EXPLAIN numbers look
>> suspiciously like default statistics ...
> Nope, forgot to on the little demonstration tables I made. I tacked the
> post-VACUUM ANALYZE explain results (they look much better) at the end of
> this email.
Ah. The plans for the little demo tables are uninteresting anyway,
but the plans for the real tables are interesting.
Next question: do you still have your 7.0.* DB up? Can you get an
EXPLAIN that shows how it did it (on the real tables)?
regards, tom lane