X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CE25932A1F8 for ; Thu, 30 Sep 2004 00:49:16 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 49655-07 for ; Wed, 29 Sep 2004 23:49:03 +0000 (GMT) Received: from mail.metnet.navy.mil (jade.metnet.navy.mil [192.16.167.28]) by svr1.postgresql.org (Postfix) with SMTP id 34F9E32A1ED for ; Thu, 30 Sep 2004 00:48:57 +0100 (BST) Received: (qmail 19440 invoked from network); 29 Sep 2004 23:48:43 -0000 Received: from unknown (HELO ?127.0.0.1?) (10.100.105.103) by mail.metnet.navy.mil with SMTP; 29 Sep 2004 23:48:43 -0000 Message-ID: <415B49DA.4000503@metnet.navy.mil> Date: Wed, 29 Sep 2004 16:48:42 -0700 From: Mike Darretta User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.3) Gecko/20040910 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Data Partition is Growing Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/281 X-Sequence-Number: 14984 I'm an application developer trying to understand a pg data partition issue. We are storing large objects (gifs) at a rate of about 1GIG /day. After about a week, most of the objects are recycled -- that is, an insert triggers a delete of a similar object. The postgres data partition, though, continues to grow, even though the objects are successfully deleted from the application *and* largeobject tables. I understand that removing an object from the database does not automatically free up disk space, but I expected to see the disk space "level out" at some point. The data partition is currently at 40Gig and growing. We are running Postgres 7.4 with the incremental vacuum process active. Any thoughts? Thanks, Mike