Re: Behaviour when autovacuum is canceled
David,
Thanks a lot for the quick reply.
I clearly misunderstood the references in the code.
Best,
Martín
On Thu, Sep 13th, 2018 at 7:55 PM, "David G. Johnston" <david.g.johnston@gmail.com> wrote:
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 lostFrom 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 по дате отправления: