Re: Need help with one query

From: Tom Lane
Subject: Re: Need help with one query
Date: ,
Msg-id: 12521.1237595840@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Re: Need help with one query  (Robert Haas)
Responses: Re: Need help with one query  (Anne Rosset)
List: pgsql-performance

Tree view

Need help with one query  (Anne Rosset, )
 Re: Need help with one query  (Richard Huxton, )
  Re: Need help with one query  (Tom Lane, )
  Re: Need help with one query  (Anne Rosset, )
   Re: Need help with one query  (Robert Haas, )
    Re: Need help with one query  (Alvaro Herrera, )
     Re: Need help with one query  (Anne Rosset, )
      Re: Need help with one query  (Robert Haas, )
    Re: Need help with one query  (Tom Lane, )
     Re: Need help with one query  (Anne Rosset, )
      Re: Need help with one query  (Robert Haas, )
       Re: Need help with one query  (Anne Rosset, )

Robert Haas <> writes:
> On Fri, Mar 20, 2009 at 1:16 PM, Anne Rosset <> 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:

From: "M. Edward (Ed) Borasky"
Date:
Subject: "iowait" bug?
From: Simon Riggs
Date:
Subject: Re: Proposal of tunable fix for scalability of 8.4