Re: Database size

From: John R Pierce <pierce(at)hogranch(dot)com>
To: l(dot)rame(at)griensu(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Database size
Date: 2010-01-11 18:32:36
Message-ID: 4B4B6EC4.3070203@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Leonardo M. Ramé wrote:
> A customer of mine asked me to periodically delete old, unneeded records
> containing ByteA fields, because he think it will reduce the database
> size on disk. Is this true?. For example, in Firebird, the database size
> is not reduced until you do a Backup-Restore of the database.
>

the space occupied by deleted tuples will available for reuse after they
are vacuumed... so it might not shrink the database but it will help
keep the database from growing.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Reyes 2010-01-11 18:35:57 Re: how much left for restore?
Previous Message Vincenzo Romano 2010-01-11 18:21:07 Re: Composite types questions