How far does interrupting vacuum full rollback?

From: Nick Urbanik <nicku(at)nicku(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: How far does interrupting vacuum full rollback?
Date: 2007-05-15 23:37:28
Message-ID: 20070515233728.GB16021@nicku.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)nicku(dot)org
GPG: 7FFA CDC7 5A77 0558 DC7A 790A 16DF EC5B BB9D 2C24 ID: BB9D2C24

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Geoff Tolley 2007-05-15 23:44:04 Re: How overcome wait for vacuum full?
Previous Message Nick Urbanik 2007-05-15 23:25:05 Re: How overcome wait for vacuum full?