Re: postmaster(s) have high load average

On Sat, 2003-08-09 at 21:25, Christopher Browne wrote:
> In 7.3 and 7.4, the "contrib" application, pg_autovacuum can do the
> trick, vacuuming anything that reaches thresholds of
> inserts/deletes/updates, and do so more or less as often as necessary.

Actually pg_autovacuum is not included with 7.3, but works just fine
once you get it compiled.

> If you haven't got a cron job looking something like:
>
> 0 0 * * * * vacuumdb -a -z > /dev/null 2> /dev/null
>
> then you should probably add that, at least.

might be better to have it only vacuum a few specific tables that cause
most of your problems.