Re: Database size - Mailing list pgsql-general

From John R Pierce
Subject Re: Database size
Date
Msg-id 4B4B6EC4.3070203@hogranch.com
Whole thread Raw
In response to Database size  ("Leonardo M." Ramé <l.rame@griensu.com>)
List 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.




pgsql-general by date:

Previous
From: Vincenzo Romano
Date:
Subject: Re: Composite types questions
Next
From: Francisco Reyes
Date:
Subject: Re: how much left for restore?