Re: Autovacuum versus rolled-back transactions

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Tom Lane wrote:
>> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
>>> If we apply Heikki's idea of advancing OldestXmin, I think what we
>>> should do is grab the value from pgstats when vacuum starts, and each
>>> time we're going to advance OldestXmin, grab the value from pgstats

>> Considering that each of those values will be up to half a second old,
>> I can hardly think that this will accomplish anything except to
>> introduce a great deal of noise ...

> Normally, yes, but the values can be older if the vacuum_cost_delay is
> large.

I'm not sure we're on the same page. I meant that whatever you read
from pgstats is going to be stale by an uncertain amount of time.
Taking the deltas of such numbers over relatively short intervals
is going to be mighty noisy.

regards, tom lane