diskspace bigger after a vacuum

From: Vincent van der Locht <vincent(at)vanderlocht(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: diskspace bigger after a vacuum
Date: 2004-06-30 12:54:55
Message-ID: 40E2B81F.2090105@vanderlocht.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-06-30 13:47:56 Implicit casting for || (was Re: grant execute on many functions)
Previous Message h_harush 2004-06-30 12:07:42 Dumping partial database content