X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id DFE709FB2DB for ; Mon, 21 Aug 2006 20:20:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 04122-08 for ; Mon, 21 Aug 2006 23:20:22 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from outbound.mailhop.org (outbound.mailhop.org [63.208.196.171]) by postgresql.org (Postfix) with ESMTP id A67199FB29F for ; Mon, 21 Aug 2006 20:20:22 -0300 (ADT) Received: from ool-435121e8.dyn.optonline.net ([67.81.33.232] helo=[192.168.0.96]) by outbound.mailhop.org with esmtpa (Exim 4.51) id 1GFJ48-0005Jy-Vp; Mon, 21 Aug 2006 19:20:21 -0400 X-Mail-Handler: MailHop Outbound by DynDNS X-Originating-IP: 67.81.33.232 X-Report-Abuse-To: abuse@dyndns.com (see http://www.mailhop.org/outbound/abuse.html for abuse reporting information) X-MHO-User: tocr Message-ID: <44EA3FD1.4020505@zeut.net> Date: Mon, 21 Aug 2006 19:20:49 -0400 From: "Matthew T. O'Connor" User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 To: Eamonn Kent CC: pgsql-admin@postgresql.org Subject: Re: Vacuum issues.. References: <9146E3EBBFBCC94D95F95A1C4065348A837AB0@exch01.xsigo.com> In-Reply-To: <9146E3EBBFBCC94D95F95A1C4065348A837AB0@exch01.xsigo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200608/237 X-Sequence-Number: 22780 Eamonn Kent wrote: > I am using PostgreSQL 8.1.4 for an embedded application. For some > reason, vacuum is not able to identify rows that are candidates for > removal (i.e., mark space as available). [snip] > > If I shutdown our application and run a vacuum full, the space is > recovered and the database size goes down to 150M. The most common answer to this is that your application is leaving open transactions just sitting there. VACUUM can't remove tuples that may still need to be visible to a transaction that's been open for days.