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 по дате отправления: