Re: Why does autovacuum run in so small blocks? - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: Why does autovacuum run in so small blocks?
Date
Msg-id 20111109213930.GA9890@depesz.com
Whole thread Raw
In response to Re: Why does autovacuum run in so small blocks?  (Bill Moran <wmoran@potentialtech.com>)
List pgsql-general
On Wed, Nov 09, 2011 at 04:37:50PM -0500, Bill Moran wrote:
> My guess would be that the vacuum was triggered by updates, but there were
> active transactions that prevented vacuum from cleaning up the dead tuples,
> so it came back later and was able to clean them up at that time.
>
> Would need to do a little more in-depth research/monitoring to determine
> if that guess is correct or not.

makes perfect sense, thanks.

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Why does autovacuum run in so small blocks?
Next
From: Alvaro Herrera
Date:
Subject: Re: Foreign Keys and Deadlocks