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 1w8BzV-000IJS-32 for pgsql-hackers@arkaria.postgresql.org; Thu, 02 Apr 2026 06:57:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w8BzT-004FdV-1E for pgsql-hackers@arkaria.postgresql.org; Thu, 02 Apr 2026 06:57:19 +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 1w8BzS-004FdL-34 for pgsql-hackers@lists.postgresql.org; Thu, 02 Apr 2026 06:57:19 +0000 Received: from mail-japaneastazon11010027.outbound.protection.outlook.com ([52.101.229.27] helo=TY3P286CU002.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w8BzQ-000000009cI-3SjN for pgsql-hackers@postgresql.org; Thu, 02 Apr 2026 06:57:18 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=jDzAfvPGL/wsLDsCQRgGviSskXxOn3VVnQQ5XSvwEmcjL+yNvgegBgs4x26QIKy7g8GajZ6jpFKF+kuyT2y1S47flYNSAiNQWrwtoZ9VvwZrHQjFbd31HCXDs44+jfsxc5bi1A09elPX2so2jv8oxyAzhk4H1dNDPtT9cta2sQSh9rDW7BmdAh9XKoG+C+/hYhLPKCn60AiD+40Wx9jdcRCJQuB9V/RtbXFcT+CxMkt8mhXm15im8ZjrJIq61CXY9vBO1jvFwBYzpveSEELLyMHJEnbKijogQU6fae4hFPtrd7r9kJ93QVeSt/ae7WHB1kJqia4aZuJH5xZr4iOAWQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=00GOBDTliVtpFRhSwFc+XGt2usn8Hp9ESLO2IXJldZs=; b=Yhg/SIf2ajkU3wV1EfvGHVFDp50Zs6tWgIYqmXdnRrqqVQ0wNty997YRfQ0d31AoxQH3baO0RFAXHlr2Qp7RsKEFYCdKOEgJVetdtlcL4WnSpWsLFBTZhxw2teNUCNyq0x0MACgu0whcIXmy92V5lvvJehNFm0Y3VAI1EN4yiIkWQZAddJvddJiAKOLKLyFvdXiVmEsTXpakWsQ7j0gGEpy150bTjW2DaUCZ+e/7OfNF1N2crPKMe11VGZQns51jLF7KlnCsxMMEBnbifJPmE5cKqNk/TMiC2HiO7DWPJzuBBFD6oLXifzjTbEjoqyNoZXSCMFch8IeYaGRTV8YOkQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fujitsu.com; dmarc=pass action=none header.from=fujitsu.com; dkim=pass header.d=fujitsu.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fujitsu.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=00GOBDTliVtpFRhSwFc+XGt2usn8Hp9ESLO2IXJldZs=; b=MQmQPo77qJxwuVUl18vUPbVVSlJPiGFv2FtSfHmmq3FC0Gizfh7fTgIZ80obLnc+l9ycIXji2BqCmfChXKBKGJ2xzHZHOw0pqe6dP/2IQ++r9tJCb89IhRyGMxi6tJTqA15wACUou8JFmw02OgzH3EyD+8Wjh73FOztu/aA7Qox50aUIW7vIVdcm26nuDwyImy9Sf76kspB7PZXmxp7hNioXJvaaR/+C/txWyDtqjppSdX20Zq1iBY6PgYC36WxK2TJPjq8gGAcvbOYgxWWOujuzxZqlXCBEeIZw7eXznMeX5xOntFVR5fGHzUAYnVxVcMNfI0sAV0JUWkUzcvorVg== Received: from OS9PR01MB12149.jpnprd01.prod.outlook.com (2603:1096:604:2e5::8) by TY4PR01MB15431.jpnprd01.prod.outlook.com (2603:1096:405:270::11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9769.18; Thu, 2 Apr 2026 06:57:10 +0000 Received: from OS9PR01MB12149.jpnprd01.prod.outlook.com ([fe80::8943:2365:dd16:e893]) by OS9PR01MB12149.jpnprd01.prod.outlook.com ([fe80::8943:2365:dd16:e893%5]) with mapi id 15.20.9769.018; Thu, 2 Apr 2026 06:57:10 +0000 From: "Hayato Kuroda (Fujitsu)" To: "Hayato Kuroda (Fujitsu)" , 'Tom Lane' , Alexander Lakhin , Michael Paquier CC: "Aya Iwata (Fujitsu)" , Peter Smith , Pavel Stehule , Chao Li , pgsql-hackers Subject: RE: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE Thread-Topic: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE Thread-Index: Adw0Q6iYueu3o2DFQ0mAqFGMYYi8fgCHrYogAANaoAAADhfaoAAkABYAAAgFebAAHqlkgAAc+sDgABamIwAAB8zgcAAA2L7gAAJh2gAAAJsSIAABnF4AAACrZPAADnLD0AAdyhgAAAccG9AAiEaFAAAGACmAAGU3sZAANwlJgAufFI0AADTJjNAACU7dgABjuTRwAAWSjQAAKB4N0AALRsgAAVn4LyACE1bdgAACmtMAAARr5QAAEDsw8AAPo6WAABFxbgANA82wUACN/cgAACIEFoAABKkbQAAEbnWAAARC6gAABVungABJ/ekAAAqMYwAAaIFmgAH/xYoAAAgwmAAADMPTAAA5SDwAAA5vxUAAB7XL8A== Date: Thu, 2 Apr 2026 06:57:10 +0000 Message-ID: References: <1020519.1773863522@sss.pgh.pa.us> <3074140.1775074810@sss.pgh.pa.us> In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_ActionId=8c8de77b-e82e-464c-8540-52b7db3a04b0;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_ContentBits=0;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Enabled=true;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Method=Standard;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Name=FUJITSU-RESTRICTED?;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_SetDate=2026-04-02T03:13:31Z;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_SiteId=a19f121d-81e1-4858-a9d8-736e267fd4c7;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Tag=10, 3, 0, 1; authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fujitsu.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: OS9PR01MB12149:EE_|TY4PR01MB15431:EE_ x-ms-office365-filtering-correlation-id: 0fbe9059-f9fb-4cf1-ef1f-08de90851011 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|366016|376014|1800799024|56012099003|22082099003|18002099003|1580799027|3613699012|38070700021; x-microsoft-antispam-message-info: QOMrw4cOTuZcjQKo451evkUdmbBju5yUzSE4qoMBcf9Sse7X4DeT7SF6kIeWVRGngYrAySSQb4pANL+//OYkRvL2kxyU1wvEZJcMnrAyqzQpA3gHGnQaYQUhBhAN9WsDQmOkzdmy2HDNy+wSQuWKE3zHP1Syg0vGWRPqTGnxOOzvkcWtTz7uatt0g02tyl6RYBmM7pZ0Kowr+IC9MPtzgdDKETWN5WsQFntsd5u52EWKXA+dwVki+OYgkf/HbE1Y+NdGF9992PQWrgwzfg92/zdOfmsYTRnUyPDpUIFKfpIVHYx/975M8hxK+rQNwFaTTlxpPdWvZgEoU3BTg5MB9no8+cgDqhRnSPLw3kHEk7FnecCWuXTd70pY8ohJCU0d/AnRZBcesq8tztSQwjFtcqPPV2ELUwzddMmElbzEwbfsxb/xQrOdBV1WWOt71PMmzHi5w7gw5CltN0CACkseV+o2nN4I3Ax+kQ0l5GZmNcXzqXWVQR5qu5ytzGHXhx2RyJJqDF39e4HJPKHstGOe7OI0viNTC/kV5R0BBJSFa/THMb8I2Bt3+ucx667rc5IiVrxdtbQJABvmtiW1MtFPY9Umgok63QbTJqb1LaWv4bphQMWy0S/BkB2afYWUx43eXbniB8plDbRv7X/QMLPOu7kub+QBBjyfDtb0zZLtVC5+GwS8MU/2++GgUysVxbhVfvYaCMdHOFR6E4iZfEiEHQxPYyxHKlLO08s6uNhXQCCHgF7CfqGoOu8WaJrVE95SRbf/dh2hI+PItkaBdrurWXHvIf09bENleFV01jD5TRmY3VjJat8d5x2uwPdiueZ+yQ9PwH0LbKyxuM9t/mLHkUlASHW2o+mzQ3jiORFIObs= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OS9PR01MB12149.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(366016)(376014)(1800799024)(56012099003)(22082099003)(18002099003)(1580799027)(3613699012)(38070700021);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-2022-jp?B?NmdISTRaWVp1dDNXaHdHbnh2bVNTMVFWYWNnYlo4YWFTYnBXYWdjanRt?= =?iso-2022-jp?B?cXZ3WVdOblUySW5IZDhDZ21tNkhHU0JzMHluZTZRNnB6UUFHaVBiOXZV?= =?iso-2022-jp?B?UkRkNnJhVFhLdHppM2I1MUU0WUlIR2swOVgwcUNZVlN3RnFtd29CWFhl?= =?iso-2022-jp?B?SUlab3dwUEt5MmpPcktVNUs5dEdKSTNJV1BrTGVFZE5FTm5kQndic0c5?= =?iso-2022-jp?B?SjJjd1QraFlkcS9pOVhuZ2x6Y2RiVklFVzE2cSt2L2dYMkFOK0cxZHhP?= =?iso-2022-jp?B?dzNFQnEvdk40S0JydlluUTUrd0V6VEQxRGI1eWJHVW5JYzhkajhveFFZ?= =?iso-2022-jp?B?ODgxVU10WlpyVHVXYkV3bWNYTUw5VWNDNldhOEZoSHZFUG9qang5YWxY?= =?iso-2022-jp?B?N21QRmZiVWw4MFRrdlBBZWp5RGE4Nk5kQkhZRWRXVFBhME5UWlp4alJT?= =?iso-2022-jp?B?VEREWXlhRUkxQ1UwM09sYkhoazRCaHMweEwxT1lZOXZYKzNreHhxTzlj?= =?iso-2022-jp?B?b0xhME9KRERlR2hlZUdkZitoQ0lwL0NzZEdZMDJPZWppVGoyeWU1K3gr?= =?iso-2022-jp?B?TVlYaXZHRzd3eG9GaDZwaW5venpOaUNzMTliWGIydXVJcE02cXlNbVNr?= =?iso-2022-jp?B?WUZlNU5heHUvalZzY3JtdVR6V0Vxekk3eDlDVis4bGRmVERqSkdYVWhW?= =?iso-2022-jp?B?Y1FTQ0tRQzgraXZGQXNrcVQxL21abFphL0R2N0htTkhPTTEzcDhuRE9V?= =?iso-2022-jp?B?RnNhSmM3K1ZBQ3JqZFZ2eVUzdWJVcEtBQStSbnQ0UUFySW96NHhESGFy?= =?iso-2022-jp?B?SksyWGRneTZtT01kTzBJN21La29XbnZZeFk3WEdYR3VHMW5RcDlxSFJm?= =?iso-2022-jp?B?K1U4ODNmRUJ1b0hNaXNocUZvTFc4bDN6WDZzVDA1MTJDQkE5UWhuNnVl?= =?iso-2022-jp?B?QkJBNEY2UEJTcnRsYzRzdDB4YWZ5Tmt0QXlJckdiR1k5NDlXeXdDR2ZQ?= =?iso-2022-jp?B?eUVQQlhUdEpwZjJCR1ZDajZKVXpJYlcvdFJra3VhMjRDcjNiSVZNMFFk?= =?iso-2022-jp?B?VGxmMFFlQ0JqVXZoeG9mZUZRYXc5ODZUc0U3RVBRQldmVjNPL1pEVUdh?= =?iso-2022-jp?B?L2RTSUpsbUJHdDFEYlIwM0h4QitwSHhINkkwR3hnZnNzZng1KzFVWnR0?= =?iso-2022-jp?B?TE9abXkyZE9iMWV6TFZXQ0lkOXRJZ3d1WlhFT3laMWEzYVlWYndtM25z?= =?iso-2022-jp?B?a0NKbkRnRDlTbWJrUzM4eUpYeGhZS1Q3cis1Z1lWdE01OEUrME54MlFj?= =?iso-2022-jp?B?TnVkelRxdEJPWWVkZVc1NVJQYzZqb294aGFkT3hadmxYdVdHWHJYV05M?= =?iso-2022-jp?B?aHRoVkNqWW1NRytJbzAxcEZGOXB2YlNqUWV3M1Q3SktEMGZWazZHQjR5?= =?iso-2022-jp?B?aDJWVkY0N0pvVnNoVkQvN0pTSW8raWtiSUlEQTBzdGQvbGdSaXJaWllV?= =?iso-2022-jp?B?TjFTVHB4RVRoYjlMQVo3cndnSzVzVkJacEtvYXBFZ3l4NmpSY3dSSTIr?= =?iso-2022-jp?B?eld0M0Vha1hoSiszdnk5OGRpOXF0RnhtN05yZXoycUN6VTd0SFJYZzN3?= =?iso-2022-jp?B?WEtiOWYxQURZNVpqYUl1dVVFbm1iRTBkZTVnWkZEZ2pmS2ZlY3c4VEFj?= =?iso-2022-jp?B?TEppdGpaVXk2NlU4ZXBnZHZHVWlGL2NMU0ZlV2xLd3FrT2FGbVhPbTV0?= =?iso-2022-jp?B?L1liVVR6akFrMXd6bXNpa2xWU0lBU1EzQmZtNXFWS3R1ZlVWQ2dqdmdT?= =?iso-2022-jp?B?dE91RlZBY2JoeWR1NjVIcEVMdTNGdHRDY3M5cGhZVUlQNjN6WFBIenVE?= =?iso-2022-jp?B?ajdtQjFnTEt1a2ZDYy83VGFxQ0J6TkhMTU9zWkJWcjNnZXh0NHBQN3JG?= =?iso-2022-jp?B?T21UNlZ5YzMzL05BMk94QU51dHIzREM2Y005WnBCU3pmWDVabi9tQkNP?= =?iso-2022-jp?B?UE1ZUnZxQ2M5VnhSbjUyMHRUZkZZNUFZMTg1akxibS9Cc0F5bnlkRSsv?= =?iso-2022-jp?B?SG05alU3aFBnSWZ2eDVUUEl5TGFteGlZaWEvUUl3b3p0WkQ1aDV2LzB2?= =?iso-2022-jp?B?dnVzV08xT3Btcng5ekphR0dCQUxjd2VCWGFjR1c0WktZZTZzTVRFYXcz?= =?iso-2022-jp?B?VzZneUk2U0h0clJTM2FGbHBFU0RIYlNiQm1WTXFhSDFVVVgzc2paeWJG?= =?iso-2022-jp?B?Wi9GWUFsVXR2VlpzUUxxMElJWU9xRm9TN0g2T3lNUVFQTDg0aHBwYUVI?= =?iso-2022-jp?B?VFFObWVLV2x1QXo1dHJaSmYzcXNueU4wY01rSStUanVEYkI0UWd0VXQz?= =?iso-2022-jp?B?dFdRbjhqNEZtT1RMQWVvOHdqZ3RzY3Q1ckxGZldDc3AxbjB1VXFBSW80?= =?iso-2022-jp?B?eWtUaWoxSjZVK3RrekhGYmhLeGpOV2k4eTF3Y0ErNXFOc2x5WkFwMFV1?= =?iso-2022-jp?B?SFAxSlE1a2RoQTlzaEJOTk1BOXNkSHpqNGlhN3BFOWdFZVFZUEJSTk01?= =?iso-2022-jp?B?OEdqMU44OD0=?= Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Exchange-RoutingPolicyChecked: tJd+AZNdsN2NZQbQh/Y/vNUnTBu2w1OdNQlcYBqFe30+Yt4ui/0SfCavNz2x+kqQMQ+doJjcTil4Y/yR2oMuFJjlkKrcVRzBAp9AIRyAtLgw9FqwmU/pjlI2iyT31MrpiGywKi7OynLPsdzWyDTdLojZ9WZ4K1qfKcQpO66a9xpXNbKcz2NTvgCYa7SRe4dzDXraehcNiw+UMUDn7LN96lTdh3DGAt1dhJT1WG+iX1PQMWpXoRCRNLYRn4D10YuWUD1DTaqCemMkA2uFasoXqMMdmu1kXuTHWyM6hY952Lf9AYaXpxgiH3diJ/qtj9IfWsDIXekeys/HrsceyBkaPw== X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: OS9PR01MB12149.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 0fbe9059-f9fb-4cf1-ef1f-08de90851011 X-MS-Exchange-CrossTenant-originalarrivaltime: 02 Apr 2026 06:57:10.7798 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: a19f121d-81e1-4858-a9d8-736e267fd4c7 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: I2LSQsbCQd3D0scBdjpZYeQWh7nmDN3xLX1DsnseZm5VQg69FSo+c4GMXXZ08BM6YJhbP8cyX+4Q5VRQkf44PSq6oN/d66T6NIWepWu8Usc= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TY4PR01MB15431 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > I feel it might be a better approach, attached one implemented the idea. Note - the patch just set the env variable to the larger value at the later= part, but of course we can restore the value set on the user. There we must do is to shorten the test time at the beginning then reset it= . Best regards, Hayato Kuroda FUJITSU LIMITED