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 1x1xyr-005W6x-1b for pgsql-committers@arkaria.postgresql.org; Thu, 03 Sep 2026 03:19:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x1xyq-00FRft-1c for pgsql-committers@arkaria.postgresql.org; Thu, 03 Sep 2026 03:19:12 +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 1x1xyq-00FRfj-0u for pgsql-committers@lists.postgresql.org; Thu, 03 Sep 2026 03:19:12 +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 1x1xyo-00000003jr8-2rej for pgsql-committers@lists.postgresql.org; Thu, 03 Sep 2026 03:19:11 +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=S8i3SLUf3gsu+Ic8rHc5/J2/XrjYrihpe6pa2wWYvSY=; b=QuZQTRdn5mntAL4proOJWmc7Ba sWJri2hPet79YFUm+Am+9w2Ebo05ja3Iz1Chk1MXbblkRPJXhfR/txdQREMN6VtpjwUqYrbuClJyB F1vQeXuh6j+VksjHpNTw4kpUWFw+/hLjOBoBvvp4QjsWsgcexPhYe7CUBtfIGbq2qZ+BOdtdkXl2u WShDjRA4Msikzrik5hfhW9jh7h8eetfknc0XVdrOWQ1uyPAzbcbOWvqSaaO24lOVNanp9RFH1SH/L vjQG0NO4VUPhdM/oqM1dAJoCzsQWhrwIvoiUK8KaSVMzQgoxDhCnwMMrlaccxuP0CEL3lBX/7QDnV oTpJbukA==; 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 1x1xyo-00BKFO-1i for pgsql-committers@lists.postgresql.org; Thu, 03 Sep 2026 03:19:10 +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 1x1xyn-00000003GGw-19XZ for pgsql-committers@lists.postgresql.org; Thu, 03 Sep 2026 03:19:10 +0000 Content-Type: multipart/mixed; boundary="===============0280856621544813823==" 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:19:10 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0280856621544813823== 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 Z3Jlc3FsLm9yZwpCYWNrcGF0Y2gtdGhyb3VnaDogMTQKCkJyYW5jaAotLS0tLS0KUkVMXzE0X1NU QUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1p dGRpZmYvNTdjMTA3MjM4MDUzNjY1NmRmODdlYmM1OTI3MGY5NjZiN2EwZjY5NQoKTW9kaWZpZWQg RmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvY2F0YWxvZy9uYW1lc3BhY2UuYyAgICAg ICAgICAgICAgICAgICAgfCAxMCArKystCi4uLi90ZXN0X21pc2MvdC8wMTVfdGVtcF9zY2hlbWFf ZXhpdF9kZWZlcnJhYmxlLnBsIHwgNTggKysrKysrKysrKysrKysrKysrKysrKwoyIGZpbGVzIGNo YW5nZWQsIDY3IGluc2VydGlvbnMoKyksIDEgZGVsZXRpb24oLSkKCg== --===============0280856621544813823==--