Re: database size growing continously - Mailing list pgsql-performance

From Matthew Wakeling
Subject Re: database size growing continously
Date
Msg-id alpine.DEB.2.00.0910291558320.19472@aragorn.flymine.org
Whole thread Raw
In response to Re: database size growing continously  (Josh Rovero <rovero@sonalysts.com>)
List pgsql-performance
On Thu, 29 Oct 2009, Josh Rovero wrote:
> Do you ever "vacuum full" to reclaim empty record space?

Unless you expect the size of the database to permanently decrease by a
significant amount, that is a waste of time, and may cause bloat in
indexes. In this case, since the space will be used again fairly soon, it
is better to just VACUUM, or autovacuum. Just make sure the free space map
can cope with it.

Matthew

--
 import oz.wizards.Magic;
   if (Magic.guessRight())...           -- Computer Science Lecturer

pgsql-performance by date:

Previous
From: Josh Rovero
Date:
Subject: Re: database size growing continously
Next
From: Ludwik Dylag
Date:
Subject: Re: database size growing continously