Re: 7.4beta2 vs 7.3.3 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 7.4beta2 vs 7.3.3
Date
Msg-id 7882.1063940382@sss.pgh.pa.us
Whole thread Raw
In response to Re: 7.4beta2 vs 7.3.3  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-hackers
Gaetano Mendola <mendola@bigfoot.com> writes:
> The default_statistics_target was already 1000 for
> postgres7.4beta2 and after setting this value to 1000
> for postgres7.3.3 I had the same explain with the same
> expected row ( almost 400 ) and the almost the same time execution.

Hmph.  Can you look into why the row count estimate is still off by 10x
with stats target 1000?  Seems like there must be some odd skew in your
data statistics.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Array Parameters on protocol 3.0
Next
From: Michael Meskes
Date:
Subject: Re: ECPG interface: 7.4beta3 compile failure; CVS tip compile failure