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: 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

view thread (3+ messages)

Message-ID: <20070516011804.GB16310@nicku.org>
Permalink:  ../20070516011804.GB16310@nicku.org/
Also on:    postgresql.org/message-id/20070516011804.GB16310@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: <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