Re: Interesting glitch in autovacuum - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Interesting glitch in autovacuum
Date
Msg-id 2052.1221068051@sss.pgh.pa.us
Whole thread Raw
In response to Re: Interesting glitch in autovacuum  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Interesting glitch in autovacuum  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Tom Lane wrote:
>> I observed a curious bug in autovac just now.  ...

> Maybe we should boot RecentGlobalXmin with InvalidOid, and ensure where
> it's going to be used that it's not that.

Good idea --- an Assert at the use sites should be sufficient.

>> Lastly, now that we have the PROC_IN_VACUUM test in GetSnapshotData,
>> is it actually necessary for lazy vacuum to avoid setting a snapshot?
>> It seems like it might be a good idea for it to do so in order to
>> keep its RecentGlobalXmin reasonably current.

> Hmm, I think I'd rather be inclined to get a snapshot just when it's
> going to finish.

I'm worried about keeping RecentGlobalXmin up to date during the
vacuums, not only at the end, because it will be used for HOT page
pruning during the vacuums.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Interesting glitch in autovacuum
Next
From: Alvaro Herrera
Date:
Subject: Re: Interesting glitch in autovacuum