Can long-running VACUUM be interrupted? - Mailing list pgsql-admin

From Andrey Zhidenkov
Subject Can long-running VACUUM be interrupted?
Date
Msg-id CAJw4d1UKbCZjP6vUTkDJZAouWazN3nX6zgn_Meg+EWZisaL2-w@mail.gmail.com
Whole thread Raw
Responses Re: Can long-running VACUUM be interrupted?  (Adrien NAYRAT <adrien.nayrat@anayrat.info>)
List pgsql-admin
I have long-running prevent wraparound VACUUM (it has been running for
6 days at the moment). The question is: if I interrupt this process in
some way (restart database, for instance), will it start from the
beginning? On the one hand, it opens a new transaction at the
beginning (according to the source code), on the other hand it updates
some data on the disk (WAL?). It confuses me. Could someone please
explain me this?
-
With best regards, Andrey Zhidenkov


pgsql-admin by date:

Previous
From: Bogdan Yakovenko
Date:
Subject: pgadmin4 - session timeout problem in browser
Next
From: Häfliger Guido
Date:
Subject: AW: logging aql queries only one table or tables of one scheme