How far does interrupting vacuum full rollback? - Mailing list pgsql-admin

From Nick Urbanik
Subject How far does interrupting vacuum full rollback?
Date
Msg-id 20070515233728.GB16021@nicku.org
Whole thread Raw
Responses Re: How far does interrupting vacuum full rollback?  ("Jim C. Nasby" <decibel@decibel.org>)
List 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@nicku.org
GPG: 7FFA CDC7 5A77 0558 DC7A 790A 16DF EC5B BB9D 2C24 ID: BB9D2C24

Attachment

pgsql-admin by date:

Previous
From: Nick Urbanik
Date:
Subject: Re: How overcome wait for vacuum full?
Next
From: Geoff Tolley
Date:
Subject: Re: How overcome wait for vacuum full?