Re: Better estimates of index correlation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Better estimates of index correlation
Дата
Msg-id 8231.1300150304@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Better estimates of index correlation  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Better estimates of index correlation  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
>> I'm not convinced you can get a sufficiently good estimate from a small
>> subset of pages.

> Note that if this requires VACUUM rather than ANALYZE, it introduces a
> problem for data warehousing users, who can go years between vacuums of
> their largest tables.

It's likely that the default estimate of zero index correlation will
work just fine for such users ...
        regards, tom lane


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Better estimates of index correlation
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Better estimates of index correlation