Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 789B69FBB6E for ; Tue, 15 May 2007 22:18:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 23942-01-3 for ; Tue, 15 May 2007 22:18:11 -0300 (ADT) X-Greylist: whitelisted by SQLgrey-1.7.5 Received: from mail13.syd.optusnet.com.au (mail13.syd.optusnet.com.au [211.29.132.194]) by postgresql.org (Postfix) with ESMTP id E7E4F9FBCA5 for ; Tue, 15 May 2007 22:18:10 -0300 (ADT) Received: from www3.nicku.org (c211-30-174-44.farfl1.nsw.optusnet.com.au [211.30.174.44]) by mail13.syd.optusnet.com.au (8.13.1/8.13.1) with ESMTP id l4G1I79j029856; Wed, 16 May 2007 11:18:07 +1000 Received: from localhost (localhost.localdomain [127.0.0.1]) by www3.nicku.org (Postfix) with ESMTP id D4E4B246DE6; Wed, 16 May 2007 11:18:06 +1000 (EST) X-Virus-Scanned: amavisd-new at example.com Received: from www3.nicku.org ([127.0.0.1]) by localhost (www3.nicku.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 0pKUk-5fJmkG; Wed, 16 May 2007 11:18:05 +1000 (EST) Received: by www3.nicku.org (Postfix, from userid 1000) id 305CF246F5B; Wed, 16 May 2007 11:18:05 +1000 (EST) Date: Wed, 16 May 2007 11:18:04 +1000 From: Nick Urbanik To: pgsql-admin@postgresql.org Subject: Re: How far does interrupting vacuum full rollback? Message-ID: <20070516011804.GB16310@nicku.org> Mail-Followup-To: pgsql-admin@postgresql.org References: <20070515233728.GB16021@nicku.org> <20070516005954.GC11533@nasby.net> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="EuxKj2iCbKjpUGkD" Content-Disposition: inline In-Reply-To: <20070516005954.GC11533@nasby.net> User-Agent: Mutt/1.4.2.2i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/133 X-Sequence-Number: 25453 --EuxKj2iCbKjpUGkD Content-Type: text/plain; charset=us-ascii; format=flowed Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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? >=20 >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? >=20 >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. --=20 Nick Urbanik RHCE http://nicku.org nicku@nicku.org GPG: 7FFA CDC7 5A77 0558 DC7A 790A 16DF EC5B BB9D 2C24 ID: BB9D2C24 --EuxKj2iCbKjpUGkD Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (GNU/Linux) iD8DBQFGSlvMFt/sW7udLCQRAvg6AJ4oKzI0vI657H0iubng52xCRRk1ZwCg0qif heQ6llXBTM1ptybZ7zYBnaE= =padZ -----END PGP SIGNATURE----- --EuxKj2iCbKjpUGkD--