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