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

From Stephen Froehlich
Subject RE: Does cancelling autovacuum make you lose all the work it did?
Date
Msg-id CH2PR06MB6470E2A863D94EAE85B4B6F2E5810@CH2PR06MB6470.namprd06.prod.outlook.com
Whole thread Raw
In response to Does cancelling autovacuum make you lose all the work it did?  ("Greg Rychlewski (LCL)" <Greg.Rychlewski@loblaw.ca>)
Responses Re: Does cancelling autovacuum make you lose all the work it did?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-novice

Hi Greg,

 

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.

 

--Stephen

 

From: Greg Rychlewski (LCL) <Greg.Rychlewski@loblaw.ca>
Sent: Friday, June 12, 2020 04:19
To: pgsql-novice@postgresql.org
Subject: Does cancelling autovacuum make you lose all the work it did?

 

I have a long running autovacuum (to prevent wraparound) that has been doing on for 6 days. I’m considering changing the autovacuum settings to be more aggressive, cancelling the current one, and then let it restart. Would the tuples its cleaned be lost if I did this?

This email message is confidential, may be legally privileged and is intended for the exclusive use of the addressee. If you received this message in error or are not the intended recipient, you should destroy the email message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained. Please inform us of the delivery error by return email. Thank you for your cooperation.

Le présent message électronique est confidentiel et peut être couvert par le secret professionnel. Il est à l’usage exclusif du destinataire. Si vous recevez ce message par erreur ou si vous n’en êtes pas le destinataire prévu, vous devez détruire le message et toute pièce jointe ou copie et vous êtes tenu de ne pas conserver, distribuer, divulguer ni utiliser tout renseignement qu’il contient. Veuillez nous informer de toute erreur d’envoi en répondant à ce message. Merci de votre collaboration.

pgsql-novice by date:

Previous
From: "Greg Rychlewski (LCL)"
Date:
Subject: Does cancelling autovacuum make you lose all the work it did?
Next
From: "David G. Johnston"
Date:
Subject: Re: Does cancelling autovacuum make you lose all the work it did?