Re: diskspace bigger after a vacuum - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: diskspace bigger after a vacuum
Date
Msg-id 1088716694.14882.10.camel@localhost.localdomain
Whole thread Raw
In response to diskspace bigger after a vacuum  (Vincent van der Locht <vincent@vanderlocht.com>)
List pgsql-admin
On Wed, 2004-06-30 at 06:54, Vincent van der Locht wrote:
> 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.

I'd look at firebirdSQL for this kind of work.  It has a naturally
smaller footprint, and can run, if I remember correctly, as a shared lib
right underneath your application.

Not that you can't slim down postgresql to fit on a smaller memory card
etc... but it's just not really built for this kind of application.


pgsql-admin by date:

Previous
From: h_harush@hotmail.com
Date:
Subject: Dumping partial database content
Next
From: debs@debbiejenkins.com (Debs)
Date:
Subject: recovery from server crash