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 DA523D1B179 for ; Wed, 30 Jun 2004 09:56:00 -0300 (ADT) 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 42648-09 for ; Wed, 30 Jun 2004 12:56:00 +0000 (GMT) Received: from smtp1.axon.nl (axon7.axon.nl [195.193.241.200]) by svr1.postgresql.org (Postfix) with ESMTP id 8BA11D1B184 for ; Wed, 30 Jun 2004 09:55:54 -0300 (ADT) Received: from vanderlocht.com ([10.1.0.37]) by smtp1.axon.nl (Lotus Domino Release 6.5) with ESMTP id 2004063014555268-5067 ; Wed, 30 Jun 2004 14:55:52 +0200 Message-ID: <40E2B81F.2090105@vanderlocht.com> Date: Wed, 30 Jun 2004 14:54:55 +0200 From: Vincent van der Locht User-Agent: Mozilla Thunderbird 0.5 (X11/20040208) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: diskspace bigger after a vacuum X-MIMETrack: Itemize by SMTP Server on Axon_Server2/Axon(Release 6.5|September 26, 2003) at 30-06-2004 14:55:52, Serialize by Router on Axon_Server2/Axon(Release 6.5|September 26, 2003) at 30-06-2004 14:56:01, Serialize complete at 30-06-2004 14:56:01 X-DNSBLSite: orbs.dorkslayers.com Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii; format=flowed 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: 200407/17 X-Sequence-Number: 14085 Hi, I have a question, I wnat to use a postgresql database in a embedded appliance, and thus want to keep the database as small as possible. I'd noticed that de diskspace only grows when i do an VACUUM; or a ./vacuumdb. Can this be explained why this is? or why this can be? i use postgresql 7.4.2 and run on fedora core 1. greetz, Vincent The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. Axon Digital Design Group is neither liable for the proper nor for the complete transmission of the information contained in this communication nor for any delay in its receipt. Axon Digital Design Group does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited. In that case please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Axon Digital Design Group applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge.