Re: Behaviour when autovacuum is canceled

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Behaviour when autovacuum is canceled
Дата
Msg-id CAKFQuwbEYMEZwfSeTHJAax0XdaAHuKRoDf3+Uuf3tJuWSNPLWQ@mail.gmail.com
обсуждение исходный текст
Ответ на Behaviour when autovacuum is canceled  (Martín Fernández <fmartin91@gmail.com>)
Ответы Re: Behaviour when autovacuum is canceled
Список pgsql-general
On Thu, Sep 13, 2018 at 3:45 PM, Martín Fernández <fmartin91@gmail.com> wrote:
From what I could understand (that can be totally wrong), the vacuum process is split in multiple small transactions. If the autovacuum is canceled, could it be possible that only the latest transaction work be lost 

From the docs:

"VACUUM cannot be executed inside a transaction block."

As it is non-transactional any work it performs is live immediately and irrevocably as it occurs.

David J.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [External] RE: Estimate time without running the query
Следующее
От: Chris Williams
Дата:
Сообщение: Re: Slow shutdowns sometimes on RDS Postgres