The consequenses of interrupted vacuum

Поиск
Список
Период
Сортировка
От Bill Moran
Тема The consequenses of interrupted vacuum
Дата
Msg-id 20161027102243.452b0bfb944bc77fe7724a83@potentialtech.com
обсуждение исходный текст
Ответы Re: The consequenses of interrupted vacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Very specific question:
Does interrupting a VACUUM (not FULL) rollback all the work it has done
so far, or is the work done on a page by page basis such that at least
some of the pages in the table have been vacuumed?

I'm asking for cases of large tables where autovacuum frequently gets
interrupted. I'm trying to understand if the partial runs are at least
making _some_ progress so the next vacuum has less to do, or if this is
a serious problem that I need to fiddle with tuning to fix.

--
Bill Moran <wmoran@potentialtech.com>


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

Предыдущее
От: Joanna Xu
Дата:
Сообщение: Re: Remove Standby (SLAVE) from Primary (MASTER) - Postgres9.1
Следующее
От: Scott Mead
Дата:
Сообщение: Re: Remove Standby (SLAVE) from Primary (MASTER) - Postgres9.1