Re: [PERFORM] autovacuum on a -mostly- r/o table - Mailing list pgsql-admin

From Tobias Brox
Subject Re: [PERFORM] autovacuum on a -mostly- r/o table
Date
Msg-id 20060927161329.GB25630@oppetid.no
Whole thread Raw
In response to autovacuum on a -mostly- r/o table  (Edoardo Ceccarelli <eddy@axa.it>)
List pgsql-admin
[Edoardo Ceccarelli - Wed at 06:08:30PM +0200]
> We also activated the autovacuum feature to give it a try and that's
> were our problems started.
(...)
> How can I configure the vacuum to run after the daily batch insert/update?

I think you shouldn't use autovacuum in your case.

We haven't dared testing out autovacuum yet even though we probably
should, so we're running vacuum at fixed times of the day.  We have a
very simple script to do this, the most important part of it reads:

echo "vacuum verbose analyze;" | psql $DB_NAME > $logdir/$filename 2>&1


pgsql-admin by date:

Previous
From: Edoardo Ceccarelli
Date:
Subject: autovacuum on a -mostly- r/o table
Next
From: Csaba Nagy
Date:
Subject: Re: [PERFORM] autovacuum on a -mostly- r/o table