Re: Vacuums taking forever :(

On Tue, Feb 03, 2009 at 08:46:37PM +0800, Phoenix Kiula wrote:
> The autovacuum was clearly not enough, so we also have a crontab that
> vacuums the tables every hour. This is PG 8.2.9.

How did you determine this?  What was it not enough for?  Which
tables?  Why didn't you tune autovacuum differently?

I think the cron jobs are your problem.

> These cron jobs are taking over 35 minutes for a vacuum! What's the
> use of a vacuum if it takes that long, and the DB performance is
> tragic in the meantime?

VACUUM uses disk bandwidth.  I suspect you are causing part of your
problem.

A
--
Andrew Sullivan
ajs@crankycanuck.ca