Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
Дата
Msg-id m42mp11sic0p8ach6n4jkiieccqfok98cu@4ax.com
обсуждение исходный текст
Ответ на Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Clustered tables and seqscan disabled
Следующее
От: Ivan Voras
Дата:
Сообщение: Bitmasks