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.96) (envelope-from ) id 1x1xyi-005W6m-18 for pgsql-committers@arkaria.postgresql.org; Thu, 03 Sep 2026 03:19:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x1xyh-00FRGJ-17 for pgsql-committers@arkaria.postgresql.org; Thu, 03 Sep 2026 03:19:03 +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.96) (envelope-from ) id 1x1xyh-00FRGB-0L for pgsql-committers@lists.postgresql.org; Thu, 03 Sep 2026 03:19:03 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1x1xye-00000002eZ8-2T9E for pgsql-committers@lists.postgresql.org; Thu, 03 Sep 2026 03:19:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=VU6Gz5mMEvWh3RaJEd7bI2fuk3HG8IaIBBGxMlCwSjE=; b=HCqw4vnt76axiPAM7kgUBIqNsr JpazCyOGWCiUjasMVeZiwcrRu49wv3ChseXFJy3wpZFW4fO5Zhv6KE/i3t3Udo0Bf8WvZnVloVmQC w9UwygyW6mTktmj1piHJ0H33wyFWhGYDOg5QJ5GPRRxW8e3HuSLCO0xR1N/Vc6BZaaYqV6rZ1ee1w fbtmeKmreXNWLlJk40+l5D+ZmXxGgndoMug6/RJCM7/3VYvNOp8w89EM5eiCPBVAHU+81UG1b8tJt FotImLvs8XpBug8NSduR0jq61dT3SnuypErvJK05kx6oGqq8c+0HOoxf3Y8BWyZig6N+rqT09f7HJ kkLtwr4g==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1x1xyd-00BKEB-1I for pgsql-committers@lists.postgresql.org; Thu, 03 Sep 2026 03:18:59 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1x1xyc-00000003GGH-0c1y for pgsql-committers@lists.postgresql.org; Thu, 03 Sep 2026 03:18:59 +0000 Content-Type: multipart/mixed; boundary="===============5622487824987015514==" MIME-Version: 1.0 From: Fujii Masao To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid backend hang during temp table cleanup in deferrable trans X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 03 Sep 2026 03:18:59 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5622487824987015514== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgYmFja2VuZCBoYW5nIGR1cmluZyB0ZW1wIHRhYmxlIGNsZWFudXAgaW4gZGVmZXJyYWJs ZSB0cmFuc2FjdGlvbnMKClByZXZpb3VzbHksIGEgc2Vzc2lvbiB0aGF0IGhhZCBjcmVhdGVkIHRl bXBvcmFyeSBvYmplY3RzIGNvdWxkIGhhbmcgZHVyaW5nCmV4aXQgaWYgaXRzIGRlZmF1bHQgdHJh bnNhY3Rpb24gbW9kZSB3YXMgU0VSSUFMSVpBQkxFIFJFQUQgT05MWSBERUZFUlJBQkxFCmFuZCBh IGNvbmN1cnJlbnQgc2VyaWFsaXphYmxlIHRyYW5zYWN0aW9uIHdhcyBwcmVwYXJlZC4gRHVyaW5n IGJhY2tlbmQKZXhpdCwgdGVtcG9yYXJ5LXJlbGF0aW9uIGNsZWFudXAgcHVzaGVkIGEgcmVndWxh ciB0cmFuc2FjdGlvbiBzbmFwc2hvdCwKd2hpY2ggaG9ub3JlZCB0aGUgc2Vzc2lvbidzIGRlZmF1 bHQgc2V0dGluZ3MgYW5kIGNvdWxkIHdhaXQgZm9yIGEgc2FmZQpzZXJpYWxpemFibGUgc25hcHNo b3QuIFNvLCBpZiB0aGUgY29uZmxpY3RpbmcgdHJhbnNhY3Rpb24gd2FzIHByZXBhcmVkLAp0aGlz IHdhaXQgY291bGQgbGFzdCBpbmRlZmluaXRlbHkuCgpUaGUgd2FpdCBvY2N1cnJlZCB3aGlsZSB0 aGUgYmFja2VuZCB3YXMgYWxyZWFkeSBleGl0aW5nIGFuZCBpbnRlcnJ1cHRzCndlcmUgaGVsZCBv ZmYsIHNvIGV2ZW4gcGdfdGVybWluYXRlX2JhY2tlbmQoKSBjb3VsZCBub3QgY2FuY2VsIGl0LiBU aGUKYmFja2VuZCB0aGVyZWZvcmUgcmVtYWluZWQgdW50aWwgdGhlIHByZXBhcmVkIHRyYW5zYWN0 aW9uIHdhcyByZXNvbHZlZC4KClRlbXBvcmFyeS1yZWxhdGlvbiBjbGVhbnVwIG9ubHkgbmVlZHMg YW4gYWN0aXZlIE1WQ0Mgc25hcHNob3QgZm9yIGZldGNoaW5nClRPQVNUIGRhdGEgZnJvbSBjYXRh bG9nIHR1cGxlcyB3aGlsZSBkcm9wcGluZyB0ZW1wb3Jhcnkgb2JqZWN0cy4gSXQgZG9lcwpub3Qg bmVlZCBhIHRyYW5zYWN0aW9uIHNuYXBzaG90IGFmZmVjdGVkIGJ5IHRoZSB1c2VyJ3MgZGVmYXVs dCBpc29sYXRpb24Kc2V0dGluZ3MuIFNvLCB1c2UgYSBjYXRhbG9nIHNuYXBzaG90IGluc3RlYWQs IHdoaWNoIHByb3ZpZGVzIHRoZSBuZWVkZWQKcHJvdGVjdGlvbiB3aXRob3V0IGVudGVyaW5nIHRo ZSBkZWZlcnJhYmxlIHNhZmUtc25hcHNob3Qgd2FpdC4KCkJhY2twYXRjaCB0byBhbGwgc3VwcG9y dGVkIHZlcnNpb25zLgoKQnVnOiAjMTk0NDEKUmVwb3J0ZWQtYnk6IEFsZXhhbmRlciBMYWtoaW4g PGV4Y2x1c2lvbkBnbWFpbC5jb20+CkF1dGhvcjogQW5kcmV5IFJhY2hpdHNraXkgPHBsMGgweXAx QGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IEFuZHJleSBCb3JvZGluIDx4NG1tbUB5YW5kZXgtdGVh bS5ydT4KUmV2aWV3ZWQtYnk6IEZ1amlpIE1hc2FvIDxtYXNhby5mdWppaUBnbWFpbC5jb20+CkRp c2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMTk0NDEtZWMyOWYzYjEzNjNiNGE2OEBwb3N0 Z3Jlc3FsLm9yZwpCYWNrcGF0Y2gtdGhyb3VnaDogMTQKCkJyYW5jaAotLS0tLS0KUkVMXzE1X1NU QUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1p dGRpZmYvY2MxZWRmYTZjMjBiNTc0MDIyMjE5ODM3NTBhZTRkNjljMmRkZDRlMwoKTW9kaWZpZWQg RmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvY2F0YWxvZy9uYW1lc3BhY2UuYyAgICAg ICAgICAgICAgICAgICAgfCAxMCArKystCi4uLi90ZXN0X21pc2MvdC8wMTVfdGVtcF9zY2hlbWFf ZXhpdF9kZWZlcnJhYmxlLnBsIHwgNTggKysrKysrKysrKysrKysrKysrKysrKwoyIGZpbGVzIGNo YW5nZWQsIDY3IGluc2VydGlvbnMoKyksIDEgZGVsZXRpb24oLSkKCg== --===============5622487824987015514==--