Re: [PERFORM] Bad n_distinct estimation; hacks suggested?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PERFORM] Bad n_distinct estimation; hacks suggested?
Дата
Msg-id 17677.1114575276@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PERFORM] Bad n_distinct estimation; hacks suggested?  (Rod Taylor <pg@rbt.ca>)
Ответы Re: [PERFORM] Bad n_distinct estimation; hacks suggested?
Список pgsql-hackers
Rod Taylor <pg@rbt.ca> writes:
> If when we have partitions, that'll be good enough. If partitions aren't
> available this would be quite painful to anyone with large tables --
> much as the days of old used to be painful for ANALYZE.

Yeah ... I am very un-enthused about these suggestions to make ANALYZE
go back to doing a full scan ...
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_restore stuck in a loop?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Disable large objects GUC