Re: is it good to disable autovacuum and schedule routine vacuum process?

On 01/04/2011 04:45 PM, AI Rumman wrote:
> I am using Postgresql 9.0.1.
> I want to know which one is good regarding  VACUUM - Routine VACUUM
> manualy or AutoVacuum.
> Recently, I found in my production that  some tables were not vacuumed
> for a good period of time when the autovacuum was enabled and the DB was
> slow. I vacuumed the DB manually and the performance was good.
> Can anyone explain why this was happened and is it good to disable
> autovacuum and schedule routine vacuum process?

Keep autovacuum enabled, and if required make it run *more* not less. If
autovacuum is keeping up with your database's write load on 8.4 and
above, you should not need to vacuum manually.

See the PostgreSQL documentation and wiki for information on tuning
autovacuum.

--
Craig Ringer