Does the work made by vaccum in the current pass is lost when interrupted?

From: Jean-Marc Lessard <Jean-Marc(dot)Lessard(at)ultra-ft(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Does the work made by vaccum in the current pass is lost when interrupted?
Date: 2020-10-08 14:57:34
Message-ID: QB1PR01MB36331EA1CFAA1D9F05C3D898940B0@QB1PR01MB3633.CANPRD01.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a large table (billions of records) which has not been vacuum and bloated.
Vacuum scale factor was left at the default.

I ran a vacuum on a DEV system and it makes several passes (scanning heap/vacuuming indexes/vacumming heap) which take more than an hour each.
On a PROD system, I may have to kill the job midway.
Should I reduce the autovacuum_work_mem of my session? Currently 1GB
Does the work made in the current pass is lost when interrupted?
Correct me if I am not right, but vacuumed indexes and heap made by the current pass will go to disk, but the heap should be rescan on the next vacuum.
I guess that the visibility map is updated only at the end of each pass.

My best regards

Thank you

Jean-Marc Lessard
Administrateur de base de données / Database Administrator

[cid:image001(dot)jpg(at)01D69D5F(dot)64DB0EA0]

Ultra Electronics Forensic Technology Inc.
T +1 514 489 4247 x4164
www.ultra-forensictechnology.com<http://www.ultra-forensictechnology.com/>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2020-10-08 18:51:15 Re: How to migrate column type from uuid to serial
Previous Message Michael Paquier 2020-10-08 08:01:02 Re: Both type of replications from a single server?