public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Stephen Froehlich <[email protected]>
Cc: Greg Rychlewski (LCL) <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Does cancelling autovacuum make you lose all the work it did?
Date: Fri, 12 Jun 2020 10:56:08 -0700
Message-ID: <CAKFQuwZc7YjsLXZwMws9+wLA828RkYbiABfDtMJuqNL==F34Dg@mail.gmail.com> (raw)
In-Reply-To: <CH2PR06MB6470E2A863D94EAE85B4B6F2E5810@CH2PR06MB6470.namprd06.prod.outlook.com>
References: <[email protected]>
<CH2PR06MB6470E2A863D94EAE85B4B6F2E5810@CH2PR06MB6470.namprd06.prod.outlook.com>
The custom here is to inline or bottom-post.
On Fri, Jun 12, 2020 at 10:41 AM Stephen Froehlich <
[email protected]> 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.
view thread (6+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Does cancelling autovacuum make you lose all the work it did?
In-Reply-To: <CAKFQuwZc7YjsLXZwMws9+wLA828RkYbiABfDtMJuqNL==F34Dg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox