Re: Correlation in cost_index()

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Correlation in cost_index()
Дата
Msg-id 11083.1033671000@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Correlation in cost_index()  (Manfred Koizar <mkoi-pg@aon.at>)
Ответы Re: Correlation in cost_index()
Список pgsql-hackers
Manfred Koizar <mkoi-pg@aon.at> writes:
> 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.

Yeah, I concluded later that that was bogus.  I've been thinking of
just using the correlation of the first index column and ignoring
the rest; that would not be great, but it's probably better than what's
there.  Have you got a better formula?
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Trigger regression test output
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Oracle beats up on Open Source Database(s) ... and