Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1pDXxx-0001jp-VV
	for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Jan 2023 21:40:01 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1pDXxw-00053z-Si
	for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Jan 2023 21:40:00 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <michail.nikolaev@gmail.com>)
	id 1pDXxw-00050u-IO
	for pgsql-hackers@lists.postgresql.org; Thu, 05 Jan 2023 21:40:00 +0000
Received: from mail-pf1-x430.google.com ([2607:f8b0:4864:20::430])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <michail.nikolaev@gmail.com>)
	id 1pDXxu-0004Ge-Jh
	for pgsql-hackers@postgresql.org; Thu, 05 Jan 2023 21:40:00 +0000
Received: by mail-pf1-x430.google.com with SMTP id 124so26350960pfy.0
        for <pgsql-hackers@postgresql.org>; Thu, 05 Jan 2023 13:39:58 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20210112;
        h=to:subject:message-id:date:from:in-reply-to:references:mime-version
         :from:to:cc:subject:date:message-id:reply-to;
        bh=VQV+fc704Wr3x6evUOJb8n2Ijxx5uXnF9bwOcN1RMyU=;
        b=QGMjv2DcT07+jUU2fexpBxa6UJvBdp2HDs1BZsBgggOU1Gtr6KygoR7gNK9N26Z0iI
         48lic1duyDpoJFi3TD7UdfAaH2jzRt91r/prQY3e7G6/Xd9rTPp8cqcNAB7+GpzeZJmG
         oTTOXYqSgtT/21ezpa9o7Ceu5pY27c9lxc86Y3NjkQxKwVlEmdf5rcG1kcRm3AD8D06Z
         BVdczaw4poAWumk98GhFxSUFoMJJE/neW2nQYWVPoA6kjpH2/M72W5DUE61mLzaJW/mV
         t6vrtYxfk3TnyggFbv+Zixbks+8MkX6PCWzYGL4YRv8okPTamFV217XNdubpPjNo4ZNx
         NgGA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20210112;
        h=to:subject:message-id:date:from:in-reply-to:references:mime-version
         :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to;
        bh=VQV+fc704Wr3x6evUOJb8n2Ijxx5uXnF9bwOcN1RMyU=;
        b=6aYcSYVQPbJZhweYfbuuE0l7CiIHyPLL4wAnBQ69RxAvGZUMbkjPLQmq2pW+XHDn5z
         GMED6R7H3D3BbbsjXJbs+VevkrlnC4bHUANr2vQeX2oWmiQM/LVgEpgPQUxDFh8NvqqE
         o1AL9OKGj2FR0THnzHL2flfpdiajoaA/thV4cfPLcm/jl03b8gDupmxpX0HHAXZBuAWY
         1r6hhqUCFIJpBTNMNaPe5QGWUktMIqpirbgXNv/osi5VP7JiXAnA9wtiGbkn7CCpSwCX
         5LRVuE/pQtQ3h1mPGabv3UkDV82GtAZOSzqK0Ab7ANCPoi1z+WqHDGGstQ/ZQB/1PP0c
         2InA==
X-Gm-Message-State: AFqh2koDh160Ln/z9dKGuXicw1ncPxGHM7U7ak5D4pzdbbircssba/Nf
	tuY87RiEu/xYwaaX7KTXB2Iy/ZuLoAM7VmNsRmRKQg2hLHrJbw==
X-Google-Smtp-Source: AMrXdXtuGzn4uY1u6MnKcT9cSM3ywqw7qfUHSr6Ta+pFQSjZdcdwCOSJ7le2J4BZAAQLHhC3xVRgCXkbW87qhE5Snyc=
X-Received: by 2002:a63:dc4b:0:b0:48b:d5e9:b338 with SMTP id
 f11-20020a63dc4b000000b0048bd5e9b338mr3915638pgj.551.1672954796093; Thu, 05
 Jan 2023 13:39:56 -0800 (PST)
MIME-Version: 1.0
References: <CANtu0ojby3eBdMXfs4QmS+K1avBc7NcRq_Ot5bnzrbwM+uQ55w@mail.gmail.com>
In-Reply-To: <CANtu0ojby3eBdMXfs4QmS+K1avBc7NcRq_Ot5bnzrbwM+uQ55w@mail.gmail.com>
From: Michail Nikolaev <michail.nikolaev@gmail.com>
Date: Fri, 6 Jan 2023 00:39:44 +0300
Message-ID: <CANtu0ojS07ptbePVENX9xfb_O8q08AZ64Y3mLCjrx3Gh1+aF5Q@mail.gmail.com>
Subject: Re: BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE
To: PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Andres Freund <andres@anarazel.de>
Content-Type: text/plain; charset="UTF-8"
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/CANtu0ojS07ptbePVENX9xfb_O8q08AZ64Y3mLCjrx3Gh1%2BaF5Q%40mail.gmail.com>
Precedence: bulk

Hello, Andres.

I apologize for the direct ping, but I think your snapshot scalability
work in PG14 could be related to the issue.

The TransactionIdRetreatedBy implementation looks correct... But with
txid_current=212195 I see errors like "could not access status of
transaction 58643736"...
So, maybe vacuum_defer_cleanup_age just highlights some special case
(something with "previous" xids on the left side of zero?)....

Thanks,
Michail.