On Wed, Aug 3, 2011 at 8:03 AM, Andy Colson <andy@xxxxxxxxxxxxxxx> wrote: > If you have lots and lots of tables, autovacuum only checks one at a time, > then wait's a bit. Did you run your test for several days? Not true. autovac naps by default 1 minute between each db. i.e. if you have 5 dbs it takes 5 minutes by default to check each database. So if autovac is on it should have run within a few minutes on his database, unless he has hundreds of dbs. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general