Re: How far does interrupting vacuum full rollback?

Dear Folks,

I would like to extend a big "Thank You" to all the great people who
answered my questions so quickly and helpfully.  I'd love to buy you
all a beer!

On 15/05/07 19:59 -0500, Jim C. Nasby wrote:
>On Wed, May 16, 2007 at 09:37:28AM +1000, Nick Urbanik wrote:
>> Will interrupting it (with Control-C) cause vacuuming of the previous
>> tables to be rolled back, or just the vacuuming of the current table?
>
>Just the current table.

Thank you!  You were absolutely right there.

>> WIll any of the work done on the current table remain if the vacuuming
>> process is interrupted?
>
>If it's had to cycle though the heap more than once due to running out
>of maintenance_work_mem (or whatever it's called in 7.3) then I believe
>some of the work will be saved.

Thanks.  It actually completed on that table before I interrupted it.
Everything is back in action, and I now breath more freely.

>> This is PostgreSQL 7.3.8.
>
>You should strongly consider upgrading to 8.2 or at least 8.1. If
>nothing else at least get on the latest 7.3 version.

Yes, I understand, but this system has been in production for some
time, and along with many others, will get an upgrade, but only when
we have time.  It's hard for a team of six people to manage around 430
servers as well as work on many other projects.  We just do the best
we can.
--
Nick Urbanik   RHCE         http://nicku.org        nicku@nicku.org
GPG: 7FFA CDC7 5A77 0558 DC7A 790A 16DF EC5B BB9D 2C24 ID: BB9D2C24