Re: Correlation in cost_index()

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: Correlation in cost_index()
Дата
Msg-id kjvopusi65nsige1l7le9tmf6ds8acd6ne@4ax.com
обсуждение исходный текст
Ответ на Re: Correlation in cost_index()  ("scott.marlowe" <scott.marlowe@ihs.com>)
Ответы Re: Correlation in cost_index()
Список pgsql-hackers
On Thu, 3 Oct 2002 10:59:54 -0600 (MDT), "scott.marlowe"
<scott.marlowe@ihs.com> wrote:
>>are multicolunm indices involved in your estimator problems?
>
>No.  Although I use them a fair bit, none of the problems I've encountered 
>so far have involved them.  But I'd be willing to setup some test indexes 
>and get some numbers on them.

Never mind!  I just stumbled over those lines in selfuncs.c where
indexCorrelation is calculated by dividing the correlation of the
first index column by the number of index columns.

I have a use case here where this clearly is not the right choice and
was hoping to find some examples that help me investigate whether my
case is somewhat uncommon ...

ServusManfred


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

Предыдущее
От: Justin Clift
Дата:
Сообщение: Re: [GENERAL] Anyone want to assist with the translationof the
Следующее
От: Lamar Owen
Дата:
Сообщение: Re: Trigger regression test output