Re: Vacuum as "easily obtained" locks

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Andy Colson <andy(at)squeakycode(dot)net>
Cc: Michael Graham <mgraham(at)bloxx(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Vacuum as "easily obtained" locks
Date: 2011-08-03 14:22:01
Message-ID: CAOR=d=34ATQGx54Rp+mpknqKK125TVuHWLGEGW_HfJuB8GH0uA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Aug 3, 2011 at 8:03 AM, Andy Colson <andy(at)squeakycode(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Konoplev 2011-08-03 14:32:58 Re: Vacuum as "easily obtained" locks
Previous Message Tom Lane 2011-08-03 14:17:52 Re: Vacuum as "easily obtained" locks