Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Ludwik DylagDate: 2009-10-29 16:00:57
Subject: Re: database size growing continously
Previous:From: Chris ErnstDate: 2009-10-29 15:58:36
Subject: Re: database size growing continously

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group