Re: Behaviour when autovacuum is canceled - Mailing list pgsql-general

From David G. Johnston
Subject Re: Behaviour when autovacuum is canceled
Date
Msg-id CAKFQuwbEYMEZwfSeTHJAax0XdaAHuKRoDf3+Uuf3tJuWSNPLWQ@mail.gmail.com
Whole thread Raw
In response to Behaviour when autovacuum is canceled  (Martín Fernández <fmartin91@gmail.com>)
Responses Re: Behaviour when autovacuum is canceled  (Martín Fernández <fmartin91@gmail.com>)
List 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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [External] RE: Estimate time without running the query
Next
From: Chris Williams
Date:
Subject: Re: Slow shutdowns sometimes on RDS Postgres