From: Nick Urbanik <nicku@nicku.org>
To: pgsql-admin@postgresql.org
Subject: How far does interrupting vacuum full rollback?
Date: Wed, 16 May 2007 09:37:28 +1000
Message-ID: <20070515233728.GB16021@nicku.org> (raw)
Dear Folks,
I would like to interrupt this full vacuum run as:
vacuum full verbose;
which has vacuumed a number of tables.
Will interrupting it (with Control-C) cause vacuuming of the previous
tables to be rolled back, or just the vacuuming of the current table?
WIll any of the work done on the current table remain if the vacuuming
process is interrupted?
This is PostgreSQL 7.3.8.
--
Nick Urbanik RHCE http://nicku.org nicku@nicku.org
GPG: 7FFA CDC7 5A77 0558 DC7A 790A 16DF EC5B BB9D 2C24 ID: BB9D2C24
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: nicku@nicku.org
Subject: Re: How far does interrupting vacuum full rollback?
In-Reply-To: <20070515233728.GB16021@nicku.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox