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 1x1xxh-005W59-13 for pgsql-committers@arkaria.postgresql.org; Thu, 03 Sep 2026 03:18:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x1xxg-00FOIU-14 for pgsql-committers@arkaria.postgresql.org; Thu, 03 Sep 2026 03:18:00 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1x1xxS-00FNTQ-1w for pgsql-committers@lists.postgresql.org; Thu, 03 Sep 2026 03:17:46 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1x1xxP-00000003joD-3i2A for pgsql-committers@lists.postgresql.org; Thu, 03 Sep 2026 03:17:45 +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=pmjIolKFawHU9yFhieajPOkJmmtl1L+O5eQAUQebepI=; b=CXYMi8y5PDkvvX2s3kO61o3GNH mPaxe80Q8jKqkhVQidEVEsbkp/nltPV4g1s8hvHW44sgtY3qb00JRf83iy0tryBCE10L0LnymYGVj /h0Qs/Xp3LuwdQR0U3YEhzHk5HW4oV4V+ShFmvCEBNe4AEe3a6BEiz+XBpHmNExCDa3RvRHFHIEKO rbRgIhQzzIXh6Lk6okjejivvYkvihuiy/rzZJG6QxTvICCvRXPmEIzZwT3AanBQLDMu8m7Za7ruNE ZD2hZzXIvfuzPD9oBCxyK7nc/yf1OgrHpVfdTPBIKy932X84zmQDoD5kg7a8X5DTa+TGQfPPHvWTQ lbDeqcTA==; 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 1x1xxP-00BKCI-1G for pgsql-committers@lists.postgresql.org; Thu, 03 Sep 2026 03:17:43 +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 1x1xxN-00000003GAF-0TJv for pgsql-committers@lists.postgresql.org; Thu, 03 Sep 2026 03:17:42 +0000 Content-Type: multipart/mixed; boundary="===============0494917050446263488==" 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:17:42 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0494917050446263488== 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 Z3Jlc3FsLm9yZwpCYWNrcGF0Y2gtdGhyb3VnaDogMTQKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpE ZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8w Yjc3NmRlMDllZDNlMjM3MTgxZGVmMTM1NTc3MzIxYmRkMzFiNTQ4CgpNb2RpZmllZCBGaWxlcwot LS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9jYXRhbG9nL25hbWVzcGFjZS5jICAgICAgICAgICAg ICAgICAgICB8IDEwICsrKy0Kc3JjL3Rlc3QvbW9kdWxlcy90ZXN0X21pc2MvbWVzb24uYnVpbGQg ICAgICAgICAgICAgfCAgMSArCi4uLi90ZXN0X21pc2MvdC8wMTVfdGVtcF9zY2hlbWFfZXhpdF9k ZWZlcnJhYmxlLnBsIHwgNTggKysrKysrKysrKysrKysrKysrKysrKwozIGZpbGVzIGNoYW5nZWQs IDY4IGluc2VydGlvbnMoKyksIDEgZGVsZXRpb24oLSkKCg== --===============0494917050446263488==--