Cancelling "vacuum full" in single user mode?

From: "Colin 't Hart" <colin(at)sharpheart(dot)org>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Cancelling "vacuum full" in single user mode?
Date: 2023-10-02 12:38:32
Message-ID: CAMon-aQM3F6NEoF-KZ1+oAZNL8xhyh51MUAROhNM7Ei3vi73kg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a customer approaching transaction wraparound, about 3million
transaction IDs away at the moment.
Postgres 9.5 (yes, I know...)

Somewhat mislead by the message to vacuum the database in single user
mode, they are now in single user mode and are running "vacuum full"
on the "worst" database, which has 18.5 million tables, and is about
350GB on disk.

Now we want to cancel the "vacuum full" and run a "vacuum freeze"
instead... or preferably, start back up in multiuser mode and run
vacuum there, but that was running very slowly while autovacuum was
trying to run (so we would need to disable that too, for now).

So,

1. Can we cancel safely?
2. Any other suggestions? Upgrade to a newer version right now?

/Colin

Browse pgsql-general by date

  From Date Subject
Next Message Colin 't Hart 2023-10-02 12:39:59 Cancelling "vacuum full" in single user mode?
Previous Message Andreas Kretschmer 2023-10-02 11:39:00 Re: How to investigate deadlocks