Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xJkqN-00000000PY1-2jUR for pgsql-bugs@arkaria.postgresql.org; Thu, 22 Oct 2026 04:56:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xJkqL-00000008eoY-2JPu for pgsql-bugs@arkaria.postgresql.org; Thu, 22 Oct 2026 04:55:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xJkqL-00000008eoQ-13Bh for pgsql-bugs@lists.postgresql.org; Thu, 22 Oct 2026 04:55:57 +0000 Received: from mail-pj1-x1035.google.com ([2607:f8b0:4864:20::1035]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xJkqI-00000000LQO-1mOc for pgsql-bugs@lists.postgresql.org; Thu, 22 Oct 2026 04:55:56 +0000 Received: by mail-pj1-x1035.google.com with SMTP id 98e67ed59e1d1-3ac9f49b984so318912a91.1 for ; Wed, 21 Oct 2026 21:55:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1792644952; x=1793249752; darn=lists.postgresql.org; h=content-transfer-encoding:content-type:in-reply-to:from :content-language:references:cc:to:subject:user-agent:mime-version :date:message-id:from:to:cc:subject:date:message-id:reply-to :content-type; bh=thlxfSXY0achXgSAW000GN6YncZsY0ZXnQpmVOaCsAo=; b=lUNAO383k8bMnNmU4jWYaRVafZMQBS2r/NO/Plz+c/TdbX6D35ux6HaTNwJbaOlX+P bmL+V4e3b3ciF+iCfqUakzt1z5wVVXYmYegmStg0ugQlznGbknMSaxRzoFDnfYzS7lL/ HPzsm3ujyYrKvFvpJP1vIqh91dBbkU0MiZDMB11tSbuvKYZoA5eXZjwL8Li2gvZja0rR PZz6wn6iEMv+dNR1rePuDN+NoDM3bGH5mq9uNmxNBzoGe1Fzys5R9irrOxfWr8iqNrmb Oj3rMj+AwkfOnBVIQ7RpxE4g28Of1E1mEk1w2FmVyP//oaR400Rs3HewfzyydKDZxVwL Wf2A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1792644952; x=1793249752; h=content-transfer-encoding:content-type:in-reply-to:from :content-language:references:cc:to:subject:user-agent:mime-version :date:message-id:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to:content-type; bh=thlxfSXY0achXgSAW000GN6YncZsY0ZXnQpmVOaCsAo=; b=oMztGcOocp4Z9R6STCq9peoLSYBqP9cGFzkbSBFF0CHs5/QGo16WUBuwIVDK2DmTsP bjdTRerArujm6u+k3oeVenQj5yN5vHoJCk5LC0CyPHPQV2lEczmJZinlr5zcXVQJyPFF aLGohq2XiyVVYYYiC9eWEDlPSoahnlmMmSKbnbsnriHl0a6L0mny5z0Ul8/h7mYBXQm/ Y/2PoI942sMSHc0q0bP9DXgN7UvkrnBY71xlkU8uLXeq9H+8LX2IPR3XvgBXoRJlhshZ fTGu/lRzaxlHgLkbk9tpXuLq5YtFS+vJ9h68z65uITE51c9xa0h/fsfQ02/G/v5SjOcW UVtw== X-Forwarded-Encrypted: i=1; AKwUvBwIKpB2ZfYHF9sNj2SFI62jWiul8m71bYd03QHAs57UdRMNLCu3KG1reE1HPeGl2oil14G64WMW/+Qr@lists.postgresql.org X-Gm-Message-State: AFq9FYJzwkv3xO1TZWPKmHXI5sKDChvg91XapZhkiZpHyOKRNw1GWaSs KlBRjZt7ya6jfDY5qZ7hkcyzRoQApCRaZzM9Ca97zDNedzRnPsk1Cj4f X-Gm-Gg: AYBFou3Ofz9N5xngfLALOdP4DumFvhSuyklRFAAH0kIhAt31funNXoe+BZJgwIsiY3G Nl7LsApvb5E3LSvwqEx4Cx7nHoD5GC4wQ2bLGYzWGO6Pol+dPOcnzYsdERE/VJt5jU2lNcy0kM5 GejUq36RXe5B2YISvDBIwhPr3RdWvHuB3uFX2mwp7kTtIfYr7nl8sx6t3VnOy3Y2gsWeehyzXHQ 1+eCQ7FS/ETuD+m7CYaWE/shwBq30fASZlz95x5pM84GT6fgIeChOI0KxoTd49b/NizHDnb35iw d/PaJvbFseR+C8IM2XGK5bSXAgKgjKrHpGA2kQU9U6T9gg1xt8NsrMDYN7RzcnUfAXziJzzcNiJ CYYtcFdT5bjNbntkjQqnv2S2FYGbAPWNeeJvKTifFzlMpH6yAtSnahn6v57fWu59qaZTE7F9ylq vnNx7f2O8/hHwT+YuFfaOEqFMYPaWmI3kNqzucsSBZqKmSTc/lQS3QlasWcs/SLFjvdCdw0uxVF MijK06VWQhrY2k8/RcZX8EJJvRhWWrBQgOuNSe0m5+ANvq+0rqHl3JWaOIvnReHtO9/0yxuOXqP 4P3z1/BB/qAqDop8QFHHKt8D048GzOw7K8c2XQ== X-Received: by 2002:a17:90b:2752:b0:3a4:b509:88bd with SMTP id 98e67ed59e1d1-3ada6c545d3mr888707a91.2.1792644952539; Wed, 21 Oct 2026 21:55:52 -0700 (PDT) Received: from [192.168.1.19] (58-190-153-33f1.hyg1.eonet.ne.jp. [58.190.153.33]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-3ada48ed70dsm2253851a91.4.2026.10.21.21.55.50 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 21 Oct 2026 21:55:52 -0700 (PDT) Message-ID: <31ce67ec-f31a-4e8d-89e5-833fbb4c648a@gmail.com> Date: Thu, 22 Oct 2026 13:55:50 +0900 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction To: Michael Paquier Cc: Zhijie Hou , shihao zhong , Ayush Tiwari , alpkeles99@gmail.com, pgsql-bugs@lists.postgresql.org References: <5fff280b-96c4-497f-bbfc-0af95b9844b3@gmail.com> <949ad7b3-2b0e-40dc-b6ac-e84da432149b@gmail.com> Content-Language: en-US From: Takeshi Ideriha In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2026/10/22 12:13, Michael Paquier wrote: > Yeah, I don't think that we should begin using SetHintBits() outside> of heapam_visibility.c when it comes down to heap as a table AM. Sure, thank you for the reply. >> However, it would still be another API violation, wouldn't it? We also >> needs to figure out the multixact race issue. I'm trying to look into >> multixact part as much as possible. > > What do you think about the first SetHintBits() added for the > subtransaction aborted case? This one seems acceptable here, by > itself.. +1 for this. Setting the hint bit for the aborted subtransaction inside HeapTupleSatisfiesVacuumHorizon is safe and not harmful for the performance. Regards, Takeshi Ideriha