Re: index scan on =, but not < ?

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: index scan on =, but not < ?
Дата
Msg-id 3oei31lc0uitgvmgfbsehm4r92ad9reas3@email.aon.at
обсуждение исходный текст
Ответ на Re: index scan on =, but not < ?  (David Brown <time@bigpond.net.au>)
Список pgsql-performance
On Thu, 10 Mar 2005 10:24:46 +1000, David Brown <time@bigpond.net.au>
wrote:
>What concerns me is that this all depends on the correlation factor, and
>I suspect that the planner is not giving enough weight to this.

The planner does the right thing for correlations very close to 1 (and
-1) and for correlations near zero.  For correlations somewhere between
0 and 1 the cost is estimated by interpolation, but it tends too much
towards the bad end, IMHO.

Servus
 Manfred

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Join method influences scan method?
Следующее
От: Manfred Koizar
Дата:
Сообщение: Re: cpu_tuple_cost