Re: Planner regression in 8.0.x ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dean Gibson (DB Administrator)" <postgresql4(at)ultimeth(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Planner regression in 8.0.x ?
Date: 2005-10-17 18:56:03
Message-ID: 10793.1129575363@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Dean Gibson (DB Administrator)" <postgresql4(at)ultimeth(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-10-17 19:02:25 Re: searching array
Previous Message Matthew Peter 2005-10-17 18:54:50 Re: searching array