From: Nick Urbanik <nicku@nicku.org>
To: pgsql-admin@postgresql.org
Subject: Re: How far does interrupting vacuum full rollback?
Date: Wed, 16 May 2007 11:18:04 +1000
Message-ID: <20070516011804.GB16310@nicku.org> (raw)
In-Reply-To: <20070516005954.GC11533@nasby.net>
References: <20070515233728.GB16021@nicku.org>
<20070516005954.GC11533@nasby.net>
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
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: <20070516011804.GB16310@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