Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae - Mailing list pgsql-bugs

From Andres Freund
Subject Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae
Date
Msg-id 20240516033308.tu3urchutxy754bp@awork3.anarazel.de
Whole thread Raw
In response to Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae  (Bowen Shi <zxwsbg12138@gmail.com>)
Responses Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae
List pgsql-bugs
Hi,

On 2024-05-16 10:21:59 +0800, Bowen Shi wrote:
> Yes,  I found the vacuum process hanging in a retry loop on PG16. I think
> it was the problem discussed in this thread. Here is some information:

Very interesting.


Do you have the page contents that triggered the issue?


> vacrel: OldestXmin = 1106, relfrozenxid = 927
> vacrel->vistest: maybe_needed = 1079, definitely_need = 1106

Do you have any other variables? E.g. RecentXmin,
ComputeXidHorizonsResultLastXmin?

Greetings,

Andres Freund



pgsql-bugs by date:

Previous
From: Tender Wang
Date:
Subject: Re: BUG #18468: CREATE TABLE ... LIKE leaves orphaned column reference in extended statistics
Next
From: Japin Li
Date:
Subject: Re: BUG #18467: postgres_fdw (deparser) ignores LimitOption