Re: Database size Vs performance degradation - Mailing list pgsql-performance

From Richard Huxton
Subject Re: Database size Vs performance degradation
Date
Msg-id 4890A261.8040802@archonet.com
Whole thread Raw
In response to Re: Database size Vs performance degradation  ("Dave North" <DNorth@signiant.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Mark Roberts
Date:
Subject: Re: Database size Vs performance degradation
Next
From: "Dave North"
Date:
Subject: Re: Database size Vs performance degradation