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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

  From Date Subject
Next Message Dave North 2008-07-30 17:39:09 Re: Database size Vs performance degradation
Previous Message Mark Roberts 2008-07-30 16:49:38 Re: Database size Vs performance degradation