pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (3+ messages)  latest in thread

Message-ID: <20070515233728.GB16021@nicku.org>
Permalink:  ../20070515233728.GB16021@nicku.org/
Also on:    postgresql.org/message-id/20070515233728.GB16021@nicku.org

 · 

reply

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