Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E9AA163296B for ; Fri, 16 Apr 2010 17:02:39 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 37132-04 for ; Fri, 16 Apr 2010 20:02:29 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 5D12463276B for ; Fri, 16 Apr 2010 17:02:29 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o3GK2RB1014241; Fri, 16 Apr 2010 16:02:27 -0400 (EDT) To: Alexandre Leclerc cc: pgsql-admin@postgresql.org Subject: Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation" In-reply-to: <4BC8A623.8090201@ipso.ca> References: <4BC8639C.4010202@ipso.ca> <9048.1271429162@sss.pgh.pa.us> <4BC8A623.8090201@ipso.ca> Comments: In-reply-to Alexandre Leclerc message dated "Fri, 16 Apr 2010 14:02:11 -0400" Date: Fri, 16 Apr 2010 16:02:27 -0400 Message-ID: <14240.1271448147@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.51 tagged_above=-10 required=5 tests=BAYES_05=-0.5, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201004/232 X-Sequence-Number: 34326 Alexandre Leclerc writes: > I'm always getting: > WARNING: db "template1" must be vacuumed within 999593 transactions > HINT: To avoid... execute a full-database VACUUM in "template1" > ... (repeated many times until 999568) Yeah, I think you will get that bleat once per table processed, until you've resolved the problem (which will likely take vacuuming each database in the installation). Don't sweat it. regards, tom lane