Can long-running VACUUM be interrupted?

From: Andrey Zhidenkov <andrey(dot)zhidenkov(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Can long-running VACUUM be interrupted?
Date: 2018-11-20 03:58:43
Message-ID: CAJw4d1UKbCZjP6vUTkDJZAouWazN3nX6zgn_Meg+EWZisaL2-w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Häfliger Guido 2018-11-20 07:05:57 AW: logging aql queries only one table or tables of one scheme
Previous Message Bogdan Yakovenko 2018-11-19 20:25:43 pgadmin4 - session timeout problem in browser