Re: Does cancelling autovacuum make you lose all the work it did? - Mailing list pgsql-novice

From David G. Johnston
Subject Re: Does cancelling autovacuum make you lose all the work it did?
Date
Msg-id CAKFQuwZc7YjsLXZwMws9+wLA828RkYbiABfDtMJuqNL==F34Dg@mail.gmail.com
Whole thread Raw
In response to RE: Does cancelling autovacuum make you lose all the work it did?  (Stephen Froehlich <s.froehlich@cablelabs.com>)
Responses Re: Does cancelling autovacuum make you lose all the work it did?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
The custom here is to inline or bottom-post.

On Fri, Jun 12, 2020 at 10:41 AM Stephen Froehlich <s.froehlich@cablelabs.com> wrote:

No autovacuum or vacuum causes no user-visible or breaking changes of any kind … it does change the performance of the database backend, but that’s all.


Um...doesn't really answer the question and besides hitting the wrap-around limit causes the server to not start in multi-user mode which is surely a user-visible effect.  Performance is a user-visible effect too - the only thing it better not impact is the correctness of the results.

To answer the original question: vacuum's effects are basically immediate so work is not lost if it gets cancelled.

David J.

pgsql-novice by date:

Previous
From: Stephen Froehlich
Date:
Subject: RE: Does cancelling autovacuum make you lose all the work it did?
Next
From: Tom Lane
Date:
Subject: Re: Does cancelling autovacuum make you lose all the work it did?