Re: Cross column statistics

Поиск
Список
Период
Сортировка
Искать
От
Greg Stark
Тема
Re: Cross column statistics
Дата
Msg-id
87u0oney8y.fsf@stark.xeocode.com
Ответ на
Re: Cross column statistics (Christopher Kings-Lynne)
Список
Дерево обсуждения
Cross column statistics Greg Stark <gsstark@mit.edu>
Re: Cross column statistics Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Cross column statistics Greg Stark <gsstark@mit.edu>
Christopher Kings-Lynne  writes:

> > B) gather a full matrix of the level of "correlation" between each column and
> >    each other column. If this were a single floating point number per pair
> >    then it might be feasible. It would still obviously be n^2 in the number of
> >    columns though, so there would have to be some way to limit on how many
> >    columns would be analyzed this way.
> 
> Use foreign keys to just record those cross-correlations.

My email was about cross-column intra-table "correlations". inter-table
"correlations" are a whole other ball of wax.

-- 
greg


В списке pgsql-hackers по дате отправления
От: Ron Mayer
Дата:
Сообщение: correlation in pg_stats
От: pgsql@mohawksoft.com
Дата:
Сообщение: Re: correlation in pg_stats
FAQ