pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feeddiskspace bigger after a vacuum
2+ messages / 2 participants
[nested] [flat]
* diskspace bigger after a vacuum
@ 2004-06-30 12:54 Vincent van der Locht <vincent@vanderlocht.com>
2004-07-01 21:18 ` Re: diskspace bigger after a vacuum Scott Marlowe <smarlowe@qwest.net>
0 siblings, 1 reply; 2+ messages in thread
From: Vincent van der Locht @ 2004-06-30 12:54 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: diskspace bigger after a vacuum
2004-06-30 12:54 diskspace bigger after a vacuum Vincent van der Locht <vincent@vanderlocht.com>
@ 2004-07-01 21:18 ` Scott Marlowe <smarlowe@qwest.net>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2004-07-01 21:18 UTC (permalink / raw)
To: Vincent van der Locht <vincent@vanderlocht.com>; +Cc: 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-07-01 21:18 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-30 12:54 diskspace bigger after a vacuum Vincent van der Locht <vincent@vanderlocht.com>
2004-07-01 21:18 ` Scott Marlowe <smarlowe@qwest.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox