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/>
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? |