Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 2F6EC9FBF2D for ; Tue, 15 May 2007 20:37:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 77595-04 for ; Tue, 15 May 2007 20:37:30 -0300 (ADT) X-Greylist: whitelisted by SQLgrey-1.7.5 Received: from mail04.syd.optusnet.com.au (mail04.syd.optusnet.com.au [211.29.132.185]) by postgresql.org (Postfix) with ESMTP id CD6209FBEC9 for ; Tue, 15 May 2007 20:37:34 -0300 (ADT) Received: from www3.nicku.org (c211-30-174-44.farfl1.nsw.optusnet.com.au [211.30.174.44]) by mail04.syd.optusnet.com.au (8.13.1/8.13.1) with ESMTP id l4FNbT60023033; Wed, 16 May 2007 09:37:30 +1000 Received: from localhost (localhost.localdomain [127.0.0.1]) by www3.nicku.org (Postfix) with ESMTP id BB7AD246DE6; Wed, 16 May 2007 09:37:29 +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 FVN2LEjHVHOo; Wed, 16 May 2007 09:37:28 +1000 (EST) Received: by www3.nicku.org (Postfix, from userid 1000) id E5E3A246F5B; Wed, 16 May 2007 09:37:28 +1000 (EST) Date: Wed, 16 May 2007 09:37:28 +1000 From: Nick Urbanik To: pgsql-admin@postgresql.org Subject: How far does interrupting vacuum full rollback? Message-ID: <20070515233728.GB16021@nicku.org> Mail-Followup-To: pgsql-admin@postgresql.org Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="tjCHc7DPkfUGtrlw" Content-Disposition: inline User-Agent: Mutt/1.4.2.2i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/126 X-Sequence-Number: 25446 --tjCHc7DPkfUGtrlw Content-Type: text/plain; charset=us-ascii; format=flowed Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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. --=20 Nick Urbanik RHCE http://nicku.org nicku@nicku.org GPG: 7FFA CDC7 5A77 0558 DC7A 790A 16DF EC5B BB9D 2C24 ID: BB9D2C24 --tjCHc7DPkfUGtrlw Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (GNU/Linux) iD8DBQFGSkQ4Ft/sW7udLCQRAgdCAJoDEHoE2qW2TbOq0XMzLN1OxGXP6QCg2Sh6 EesVwunv76JQsXQ9t7/Ukdk= =kLbV -----END PGP SIGNATURE----- --tjCHc7DPkfUGtrlw--