Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 - Mailing list pgsql-performance

From Manfred Koizar
Subject Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
Date
Msg-id m42mp11sic0p8ach6n4jkiieccqfok98cu@4ax.com
Whole thread Raw
In response to Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Mon, 05 Dec 2005 10:11:41 -0500, Tom Lane <tgl@sss.pgh.pa.us>
wrote:
>> Correlation        -0.0736492
>> Correlation        -0.237136

>That has considerable impact on the
>estimated cost of an indexscan

The cost estimator uses correlationsquared.  So all correlations
between -0.3 and +0.3 can be considered equal under the assumption
that estimation errors of up to 10% are acceptable.
Servus
 Manfred

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Clustered tables and seqscan disabled
Next
From: Ivan Voras
Date:
Subject: Bitmasks