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
|
Список | 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 по дате отправления: