| 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: | Whole Thread | Raw Message | 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? |