Re: Concurrent VACUUM and ANALYZE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Concurrent VACUUM and ANALYZE
Дата
Msg-id 20922.1216693161@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Concurrent VACUUM and ANALYZE  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Ответы Re: Concurrent VACUUM and ANALYZE  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Список pgsql-hackers
"Jonah H. Harris" <jonah.harris@gmail.com> writes:
> The case I'm looking at is a large table which requires a lazy vacuum,
> and a zero vacuum cost delay would cause too much I/O.  Yet, this
> table has enough insert/delete activity during a vacuum, that it
> requires a fairly frequent analysis to maintain proper plans.  I
> patched as mentioned above and didn't run across any unexpected
> issues; the only one expected was that mentioned by Alvaro.

I don't find this a compelling argument, at least not without proof that
the various vacuum-improvement projects already on the radar screen
(DSM-driven vacuum, etc) aren't going to fix your problem.
        regards, tom lane


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

Предыдущее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: Concurrent VACUUM and ANALYZE
Следующее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: Concurrent VACUUM and ANALYZE