From: Richard Huxton <dev@archonet.com>
To: Dave North <DNorth@signiant.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Database size Vs performance degradation
Date: Wed, 30 Jul 2008 18:18:25 +0100
Message-ID: <4890A261.8040802@archonet.com> (raw)
In-Reply-To: <35FABCF85D99464FB00BC5123DC2A70A051D0FEC@s228130hz1ew09.apptix-01.savvis.net>
References: <35FABCF85D99464FB00BC5123DC2A70A051D0FB8@s228130hz1ew09.apptix-01.savvis.net>
<48905E59.9040007@archonet.com>
<35FABCF85D99464FB00BC5123DC2A70A051D0FEC@s228130hz1ew09.apptix-01.savvis.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, DNorth@signiant.com
Subject: Re: Database size Vs performance degradation
In-Reply-To: <4890A261.8040802@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox