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

Re: Database size Vs performance degradation

From: Richard Huxton <dev(at)archonet(dot)com>
To: Dave North <DNorth(at)signiant(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Database size Vs performance degradation
Date: 2008-07-30 17:18:25
Message-ID: 4890A261.8040802@archonet.com (view raw or flat)
Thread:
Lists: pgsql-performance
Dave North wrote:
> -----Original Message-----
> From: Richard Huxton [mailto:dev(at)archonet(dot)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

In response to

pgsql-performance by date

Next:From: Dave NorthDate: 2008-07-30 17:39:09
Subject: Re: Database size Vs performance degradation
Previous:From: Mark RobertsDate: 2008-07-30 16:49:38
Subject: Re: Database size Vs performance degradation

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