Re: Planner regression in 8.0.x ?

"Dean Gibson (DB Administrator)" <postgresql4@ultimeth.com> writes:
> The following query ran in a fraction of a second on 7.4.8:
> ...
> On 8.0.4, it runs for hours (stopped after two hours).  Here's the plan:

Do you have the plan used by 7.4?

BTW, this is not really on-topic for pgsql-general; pgsql-perform would
be a more appropriate forum.

            regards, tom lane