Postgres Pro
Downloads
Home   >   mailing lists

Re: Planner regression in 8.0.x ? - Mailing list pgsql-general

From Tom Lane
Subject Re: Planner regression in 8.0.x ?
Date
Msg-id 10793.1129575363@sss.pgh.pa.us
Whole thread Raw
In response to Planner regression in 8.0.x ?  ("Dean Gibson (DB Administrator)" <postgresql4@ultimeth.com>)
Responses Re: Planner regression in 8.0.x ?
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: searching array
Next
From: "Jim C. Nasby"
Date:
Subject: Re: [pgsql-advocacy] Oracle buys Innobase