Re: database size growing continously

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: Josh Rovero <rovero(at)sonalysts(dot)com>
Cc: Peter Meszaros <pme(at)prolan(dot)hu>, pgsql-performance(at)postgresql(dot)org
Subject: Re: database size growing continously
Date: 2009-10-29 16:00:18
Message-ID: alpine.DEB.2.00.0910291558320.19472@aragorn.flymine.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ludwik Dylag 2009-10-29 16:00:57 Re: database size growing continously
Previous Message Chris Ernst 2009-10-29 15:58:36 Re: database size growing continously