Re: Why does autovacuum run in so small blocks?

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why does autovacuum run in so small blocks?
Date: 2011-11-09 21:39:30
Message-ID: 20111109213930.GA9890@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2011-11-09 21:51:42 Re: Foreign Keys and Deadlocks
Previous Message Bill Moran 2011-11-09 21:37:50 Re: Why does autovacuum run in so small blocks?