Re: Does "correlation" mislead the optimizer on large

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Does "correlation" mislead the optimizer on large
Дата
Msg-id 21093.1043439741@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Does "correlation" mislead the optimizer on large  (Ron Mayer <ron@intervideo.com>)
Ответы Re: Does "correlation" mislead the optimizer on large
Re: Does "correlation" mislead the optimizer on large
Список pgsql-performance
Ron Mayer <ron@intervideo.com> writes:
> A proposal.... (yes I I'm volunteering if people point me in the right
> direction)... would be to have a "plugable" set of analyze functions so that a
> huge database that runs analyze infrequently could choose to have a very slow
> analyze that might work better for it's data.

I do not think ANALYZE is the problem here; at least, it's premature to
worry about that end of things until you've defined (a) what's to be
stored in pg_statistic, and (b) what computation the planner needs to
make to derive a cost estimate given the stats.

            regards, tom lane

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

Предыдущее
От: Ron Mayer
Дата:
Сообщение: Re: Does "correlation" mislead the optimizer on large
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Having trouble with backups (was: Re: Crash Recovery)