Re: BETWEEN optimizer problems with single-value

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: BETWEEN optimizer problems with single-value
Дата
Msg-id 1142467626.3859.207.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: BETWEEN optimizer problems with single-value  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BETWEEN optimizer problems with single-value
Список pgsql-performance
Дерево обсуждения 
On Wed, 2006-03-15 at 14:17 -0500, Tom Lane wrote:

> It looks to me like this is a matter of bad cost estimation, ie, it's
> thinking the other index is cheaper to use.  Why that is is not clear.
> Can we see the pg_stats rows for ctofcNo and calDate?

ISTM that when the BETWEEN constants match we end up in this part of
clauselist_selectivity()...

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: [HACKERS] BETWEEN optimizer problems with single-value
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: BETWEEN optimizer problems with single-value