Postgres Pro
Downloads
Home   >   mailing lists

Re: Need help with one query - Mailing list pgsql-performance

From Tom Lane
Subject Re: Need help with one query
Date
Msg-id 12521.1237595840@sss.pgh.pa.us
Whole thread Raw
In response to Re: Need help with one query  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Need help with one query  (Anne Rosset <arosset@collab.net>)
List pgsql-performance
Tree view 
Robert Haas <robertmhaas@gmail.com> writes:
> On Fri, Mar 20, 2009 at 1:16 PM, Anne Rosset <arosset@collab.net> wrote:
>> The db version is 8.2.4

> Something is wrong here.  How can setting enable_seqscan to off result
> in a plan with a far lower estimated cost than the original plan?

Planner bug no doubt ... given how old the PG release is, I'm not
particularly interested in probing into it now.  If Anne can still
reproduce this behavior on 8.2.something-recent, we should look closer.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Jignesh K. Shah"
Date:
Subject: Re: Proposal of tunable fix for scalability of 8.4
Next
From: Robert Haas
Date:
Subject: Re: Need help with one query