Re: Confirmation of bad query plan generated by 7.4 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Confirmation of bad query plan generated by 7.4
Date
Msg-id 16554.1150339015@sss.pgh.pa.us
Whole thread Raw
In response to Re: Confirmation of bad query plan generated by 7.4  (Jim Nasby <jnasby@pervasive.com>)
Responses Re: Confirmation of bad query plan generated by 7.4  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-performance
Jim Nasby <jnasby@pervasive.com> writes:
> On Jun 13, 2006, at 8:50 PM, Tom Lane wrote:
>> Hmm ... worksforme.  Could you provide a complete test case?

> decibel=# create table date_test(d date not null, i int not null);
> [etc]

Not sure what you are driving at.  The estimates are clearly not
defaults (the default estimate would be 1/3rd of the table, or
about 100mil rows).  Are you expecting them to be the same?  If so why?
The comparison values are slightly different after all.

            regards, tom lane

pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Confirmation of bad query plan generated by 7.4
Next
From: Greg Stark
Date:
Subject: Re: Postgres fsync off (not needed) with NetApp