pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
diskspace 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>
  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-07-01 21:18  Scott Marlowe <smarlowe@qwest.net>
  parent: Vincent van der Locht <vincent@vanderlocht.com>
  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