Re: WIP: multivariate statistics / proof of concept

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: WIP: multivariate statistics / proof of concept
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B17D73648@ntex2010a.host.magwien.gv.at
обсуждение исходный текст
Ответ на WIP: multivariate statistics / proof of concept  (Tomas Vondra <tv@fuzzy.cz>)
Ответы Re: WIP: multivariate statistics / proof of concept  (Tomas Vondra <tv@fuzzy.cz>)
Список pgsql-hackers
Tomas Vondra wrote:
> attached is a WIP patch implementing multivariate statistics.

I think that is pretty useful.
Oracle has an identical feature called "extended statistics".

That's probably an entirely different thing, but it would be very
nice to have statistics to estimate the correlation between columns
of different tables, to improve the estimate for the number of rows
in a join.

Yours,
Laurenz Albe

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

Предыдущее
От: Fabrízio de Royes Mello
Дата:
Сообщение: Re: Proposal : REINDEX SCHEMA
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: [9.4 bug] The database server hangs with write-heavy workload on Windows