Message-ID: <4890A261.8040802@archonet.com>
Date: Wed, 30 Jul 2008 18:18:25 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 2.0.0.16 (X11/20080707)
MIME-Version: 1.0
To: Dave North <DNorth@signiant.com>
CC: pgsql-performance@postgresql.org
Subject: Re: Database size Vs performance degradation
References: 
 <35FABCF85D99464FB00BC5123DC2A70A051D0FB8@s228130hz1ew09.apptix-01.savvis.net>
	<48905E59.9040007@archonet.com>
	<35FABCF85D99464FB00BC5123DC2A70A051D0FEC@s228130hz1ew09.apptix-01.savvis.net>
In-Reply-To: 
 <35FABCF85D99464FB00BC5123DC2A70A051D0FEC@s228130hz1ew09.apptix-01.savvis.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dave North wrote:
> -----Original Message-----
> From: Richard Huxton [mailto:dev@archonet.com] 

> 
> Well, that's pretty much the definition of bloat. Are you sure you're
> vacuuming enough?
> 
> DN: Well, the auto-vac is kicking off pretty darn frequently...around
> once every 2 minutes.  However, you just made me think of the obvious -
> is it actually doing anything?!  The app is pretty darn write intensive
> so I wonder if it's actually able to vacuum the tables?

If you've got a big batch delete, it can't hurt to manually vacuum that 
table immediately afterwards.

-- 
   Richard Huxton
   Archonet Ltd