On Fri, May 28, 2010 at 2:02 PM, Sakari Maaranen <s...@iki.fi> wrote: > The documentation says that the best way to use autovacuum is to let the > database vacuum often. However when the tables are very large, this can take > a very long time. >
In addition to Tom's comments, as of 8.4 this is no longer true as well. The running time of VACUUM should be related to the amount of the table which has been dirtied, not the total size of the table. It's not perfect (yet) though. If you have large indexes they have to be scanned as well, and periodically a vacuum freeze has to happen which does have to scan the whole table but that's at a much longer interval than the frequent vacuums. -- greg -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
