Re: Vacuum as "easily obtained" locks - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Vacuum as "easily obtained" locks
Date
Msg-id CAOR=d=34ATQGx54Rp+mpknqKK125TVuHWLGEGW_HfJuB8GH0uA@mail.gmail.com
Whole thread Raw
In response to Re: Vacuum as "easily obtained" locks  (Andy Colson <andy@squeakycode.net>)
List pgsql-general
On Wed, Aug 3, 2011 at 8:03 AM, Andy Colson <andy@squeakycode.net> 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.

pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: Vacuum as "easily obtained" locks
Next
From: Tom Lane
Date:
Subject: Re: Vacuum as "easily obtained" locks