Joshua D. Drake wrote:
> Just my own two cents. First I am not knocking the work that has been
> on autovacuum. I am sure that it was a leap on its own to get it to
> work. However I will say that I just don't see the reason for it.
The major reasons for autovacuum as I see it are as follows:
* Reduces administrative overhead having to keep track of what tables
need to be vacuumed how often.
* Reduces the total amount of time the system spends vacuuming since it
only vacuums when needed.
* Keeps stats up-to-date automatically
* Eliminates newbie confusion
* Eliminates one of the criticisms that the public has against
PostgreSQL (justifed or not)
Also, as VACUUM improves, autovacuum will improve with it.