Re: Vacuums taking forever :(

On Tuesday 03 February 2009, Phoenix Kiula <phoenix.kiula@gmail.com> 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 it wasn't enough? As others have stated, you're
causing your own slowdown by running vacuum so much on tables that aren't
changing.

If you have a particular table that needs more frequent vacuums, like a
session table or something, maybe just cron that. But autovacuum should be
doing it more often than an hour anyway in that case ...

--
Alan