Thread: is it good to disable autovacuum and schedule routine vacuum process?
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?
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?
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