From: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
To: "Aya Iwata (Fujitsu)" <iwata.aya@fujitsu.com>
CC: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: RE: [PROPOSAL] Termination of Background Workers for ALTER/DROP
 DATABASE
Thread-Topic: [PROPOSAL] Termination of Background Workers for ALTER/DROP
 DATABASE
Thread-Index: Adw0Q6iYueu3o2DFQ0mAqFGMYYi8fgCHrYog
Date: Mon, 6 Oct 2025 01:59:08 +0000
Message-ID: 
 <OSCPR01MB149662AEA64F4E66F494C2584F5E3A@OSCPR01MB14966.jpnprd01.prod.outlook.com>
References: 
 <OS7PR01MB11964335F36BE41021B62EAE8EAE4A@OS7PR01MB11964.jpnprd01.prod.outlook.com>
In-Reply-To: 
 <OS7PR01MB11964335F36BE41021B62EAE8EAE4A@OS7PR01MB11964.jpnprd01.prod.outlook.com>
Accept-Language: ja-JP, en-US
Content-Language: ja-JP
msip_labels: 
 MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_ActionId=36deda91-75da-4e49-9b2f-6d9d6af3de90;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=2025-10-03T08:53:43Z;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: OSCPR01MB14966:EE_|OSCPR01MB13085:EE_
x-ms-office365-filtering-correlation-id: 0ccd7510-59d8-42b5-cab8-08de047bf00c
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: 
 BCL:0;ARA:13230040|366016|1800799024|376014|38070700021|1580799027|3613699012;
x-microsoft-antispam-message-info: 
 =?iso-2022-jp?B?ZHIwSURNSFM2dEtoUzR3c3VSanVaSDJnaHAyZzgxbTFSSGNKWnZ6YVNX?=
 =?iso-2022-jp?B?b2pLSnpCRGFNdWFqUGM3ZHp0K1ltMGhtMGYyTzhySVlpdnR4aU14VGVi?=
 =?iso-2022-jp?B?MzMybjhhelBQYXBrcG4zR1FUcHEvbU01bDFreE9Kd2hSaHR3ckhXOWxm?=
 =?iso-2022-jp?B?VHJ6OUJveVpnR3c0VFVNZG9ycUdhUFd5UDdCaElIbXZDN1EyNzBDeFZt?=
 =?iso-2022-jp?B?L2NMUUNFN1VRQksvSDQ0SzY1em9rdW5yVGs5b1VCa0ZvTUJWOGYyc01V?=
 =?iso-2022-jp?B?dE0ybEU3T0VWS1dVaGlIbnl2elJDNzBiRmFVSkJ6T3J6R1VpUGFvZzV6?=
 =?iso-2022-jp?B?VzVYckZFUitVUkI3VU9SSVBqS29SYlcwYi9ITGIwb3lFSEY1TVgzWlJt?=
 =?iso-2022-jp?B?RG1xcnc5VFpYVTFMc2xON3VMZGdPdmtzalc3SVZCOEYwT2VDVWhTcFFD?=
 =?iso-2022-jp?B?MVBSdkpUd2lCekJobUk2aE9HMC9ydzFwR0wzaWwwQ1d0ZWpvdjQ1bFdj?=
 =?iso-2022-jp?B?NjJWeFIwQWFXejEvbjJmV2x5L1g1OGxHRVE4TkJLK0NLaTloMTRCWGZ0?=
 =?iso-2022-jp?B?Z0ZQR3hNSS9NektaUUlYbVhYWTQ0RE9LNGkzZ0lrclJVbEF1ajlSaUIr?=
 =?iso-2022-jp?B?YzZMQzFqWUFZV2JqaWZnSHVXU1dUTzZYeUVxUnRRZ29YZVZORjUvaUFY?=
 =?iso-2022-jp?B?RHdNdS91akZVY3U3RFdHSU5qdVluRWozVTVGRFhMNk43QnFoRWNEZU42?=
 =?iso-2022-jp?B?RGUzOUxJdmhUYTAzS0ZYMC9oMVRkdTAwYTJkN0RlSmJ2elkzREQrbUhm?=
 =?iso-2022-jp?B?bU0vcVN0dHFicHFQZ0FmUWZSQVdCVkVaQ0JaeEFGZWNZTi9jN1JUQUcv?=
 =?iso-2022-jp?B?QzVhMnhMTlhPelBnMm55Y3Z5MXc0Qmgrb2JCNUZpRlM0WnZTSkpMNHRt?=
 =?iso-2022-jp?B?UEVkMUNFSVp6TjFKYzNzZ2E3eWtRNExzV0hLVmxPWlljQTBjVjh0ZjZt?=
 =?iso-2022-jp?B?QmR1bXlJS0xaMk1WVjRoR3ZRMG95c2tRcjhhY3hRT3orc21sc0YwVGRC?=
 =?iso-2022-jp?B?cVpuR25zVmt5aS8rRlZZeVcyTVJhOHNTcmoxT2s3T29uMFZTMlFpc1Bi?=
 =?iso-2022-jp?B?YnNiMWdXWXJCSCtiVHN6ck9lVEZsYWNBcGw1U0RUd0pZTEhVdEVpNnNR?=
 =?iso-2022-jp?B?T1JDU25Kd2xOcVRFMm55bENqdDNtY1M3MnRkdWFGTmVleDVkL3pvTk50?=
 =?iso-2022-jp?B?cjRkajBnMDhQMGk4cnZBT2RqbTBHejNwQWRWVmhwNEtab2ZwdWRpMGo4?=
 =?iso-2022-jp?B?R0dieTYvN3RIQm1jRm5lOEFSUTFVa2RyeitaWGR2b3lEZlNVTjZhd3F0?=
 =?iso-2022-jp?B?UDAvUENjM0kxSE9tSFNvWWlVTjk3UEEvN0ZZcGpGcFJhNHhZY3Q3S1lM?=
 =?iso-2022-jp?B?bE1NanFmMGJjYnJKd29MejVTMWtFZ21tYzNrK0dPSmxaaktwUHl4R0Fw?=
 =?iso-2022-jp?B?eUtZMmF2Zm5NVnFBR1Q0NGNTbzcxVzJhWDdqSjdWN0R0a1dScDBTQVRa?=
 =?iso-2022-jp?B?WWVldHYwcTFlV29vYitNWXdyWU12REZia09uQUVnWDUyL3NzZjB6eWhH?=
 =?iso-2022-jp?B?eSt5WEVKTDBlN09Kb0N6N2FxVXFTakVZQTA4c1FVS091QUZCeExHTlU5?=
 =?iso-2022-jp?B?aGNzZjdiWlhaUGhJbmI3d1JMTUgvdlBKMGxkRkNQS1Z5NTgrWUJ3TlZk?=
 =?iso-2022-jp?B?K0dTWW9NOXVMemU0OGhjc1A4cWxNbGVCU3huUG1uN05Jd3pZa1FJd2Ez?=
 =?iso-2022-jp?B?Z0dsVmJsQmdqSmRHYVNmOTk4Y1phZnNhVVJOWjczcVIyakI2cTduMXg2?=
 =?iso-2022-jp?B?dEJNV0RMcVNGbnpkUmVyRnQ4dnlYMVFROEc1SHJxUHhOZm9UZE1qaGhC?=
 =?iso-2022-jp?B?Zk54WENzdzVQcHlCSlpiNUQxNytGMnl0bHU2bXpDbDBVb3NqZmo3RTUr?=
 =?iso-2022-jp?B?VlJtMWlhN2lWcnhpREVhZjV1V2JWbXRCMUFSRGtoN2FsNUhHSHZWd3k0?=
 =?iso-2022-jp?B?NFBZL0xDWGtmeTJYOTJId2JNMENsNkRvbjlXOU1MaFBEY2NLVEdDajBK?=
 =?iso-2022-jp?B?OXM0VXFKTW5EUGZ0K0p3R0k4SlBrT0k5S0NTZVM2WEo3N3NQSnhLT1pa?=
 =?iso-2022-jp?B?OGNZQzVQT0ZwS3V1TEN1TEhlaFZxOTNmZ3BBcDZNQ0s4WTkrTjAyWERl?=
 =?iso-2022-jp?B?My9KQnZyeElpajBINFBGdXFiQ09qdTVNVjJTbnQ3UWt4bUpLcHJyQ2tS?=
 =?iso-2022-jp?B?SnRVOA==?=
x-forefront-antispam-report: 
 CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OSCPR01MB14966.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(366016)(1800799024)(376014)(38070700021)(1580799027)(3613699012);DIR:OUT;SFP:1101;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-2022-jp?B?ZzhoSzZZcDloSU92WVEwWDN6ZmNTcTRQR29BcXN5Q0YzaW1rK05SdWdS?=
 =?iso-2022-jp?B?NWVWazVaUEh5THNYQ0dDRyt1SlFiVC85YjMxMXo2N2x2WlhyRG9wTFNB?=
 =?iso-2022-jp?B?NEpjRXhlVzMxeUFRL1kvQ3JRVk9jNVl0WUZJalJOVFFQRFc3N1lRZzgy?=
 =?iso-2022-jp?B?ajV4aVc1UllobVh5a0M5T2xubnlmRlZtSHdqQWVWWnFrd3kwaVJkUWV1?=
 =?iso-2022-jp?B?eGxJWGhscUZuTi90Y0J0WmJSQlRTRGVnUzhZTEFQZGttbS9NRVYvKzdJ?=
 =?iso-2022-jp?B?ZmNJeWExRzFhSlYyKzJqTDVZRUErRkxyTjRYZXVzOGdMQU5pUkI5ZFJY?=
 =?iso-2022-jp?B?Y0djNUp4UkZnaE91UmgwelhaSmMwc3kwWk9qb3NpYXZmMDU5a2EwclY1?=
 =?iso-2022-jp?B?TWRtcEtPd3BKSTMvSjd0ZVFoL0swVDVBOTcyU0pvclN1ZU1sMzYzWWtV?=
 =?iso-2022-jp?B?ejlDZERtQjNmT3BreWMzVXc4NVJXcWd6RWRVdmZYdjVpb0RXUmJIQUNi?=
 =?iso-2022-jp?B?M1JYclJ2VHIra2haT1RDNHlmUmJKTXFnTHl4Zjh0RGQ4dW83QVFYR1p3?=
 =?iso-2022-jp?B?WGpKNlZYenhuZHpkckhpbGJxMDd5VzY2b3l6VkY5N1pXTm54RjBHU2xx?=
 =?iso-2022-jp?B?MTY4QUNJdWVwZk5lNDBFRFJTNlpPenhOMStKN2RDYnpMaG1tdEM0VHVz?=
 =?iso-2022-jp?B?dzVUbDRyZGhRUzU0NXFOQndwV0E0YlJqSFp3WWQ5eTlNMWtUNG9ZRUJF?=
 =?iso-2022-jp?B?TXQ1T2p6SG1QZTcyOWk0VHIxM3VlNnd1NmJ4SlQwWEw5MmV5SUgxdVJn?=
 =?iso-2022-jp?B?a0htWHZoWmRzM3c3WHVoQ0RiWDhaRmNpYklxY3N4LzFwTXJ0djBEWHRp?=
 =?iso-2022-jp?B?ODlQa0MwcVlRdHNzMHkrd0pta2VpSXRLZzRydEc5eEdBREVRbGxyUlNE?=
 =?iso-2022-jp?B?M1NPcmFhQm1keEZNdGJSekx3RVIxTlNaMUpaajQ4bTJ2T3lkOEdDajRZ?=
 =?iso-2022-jp?B?eWNiRWtMUHA5U2pDNUZqOFdBQWFwTk9XT1ZNZWw2emlMUnNqVk1rNExa?=
 =?iso-2022-jp?B?cVp5NmovQmE2T1NaR2xnTU9RclFaWDREZm0yVExtbmJaTG8zT2VraTls?=
 =?iso-2022-jp?B?aDhycXRtZk1LdW9tSEQ2OW05L0YrQlR6RXIwTkd2WUs4ZzJnMk05dEFD?=
 =?iso-2022-jp?B?eEloaENlb1AvY0t3SzVwU2JDU0J3WU5GdTl0c3ZSZjFha21nREVOWWJ6?=
 =?iso-2022-jp?B?RldReEVkTXMrdjhLZ081eDNPKzBOc2JvcWNoZ1ErV1lRWFB1VGlnQzRY?=
 =?iso-2022-jp?B?ZnZXaW1pOFEyQkpycjFmYVBkaFE0VDV5K014YVl2MzV1dnlIUVY4Q0kz?=
 =?iso-2022-jp?B?bGZjUFAwUnVxazNMZ09UMFZGZUNyaXk5MG1BalVnZjFvcGpXejltWHBJ?=
 =?iso-2022-jp?B?Z1FDWE5xN2FzK0NxQ0c1TTdJT085eWF0dVEyZ1ZsVk1ZRjlOY0M1Zjk1?=
 =?iso-2022-jp?B?MllMRUthQkc5NW5ablJici9vNVJLa3M0U3RyNnJLeXJKTHZLdW9uNHhm?=
 =?iso-2022-jp?B?cFhnN0twdnRlUVl0MVB1dm92MFJpN3owZ09kUmh6Y3Z0aFVrMkJ2WWxD?=
 =?iso-2022-jp?B?L3RsdVFuWXFEaVBCbGJzV2RRdjhpbDkwVkVISVg1Ryt0d1ptZXZGQ01j?=
 =?iso-2022-jp?B?WjhVRFRSSmZqcWxjR0lPaFJUMUQ5MTRqUFpEcmJQcUdWcGxDQ214MEFt?=
 =?iso-2022-jp?B?Rm1McnZaN3hLVEF6dG51dGU0eVNRVTd4MnQ3RXVnRTdGekZETTVuazV4?=
 =?iso-2022-jp?B?QjBMUTN3YWJoanYycEcyMzBKT05HVCt0OGJwRWYvdHVycCs4Zm9JVzFO?=
 =?iso-2022-jp?B?eS9FY1QycllBVi9Kb0ZQWDUyWTduT0xxTE1CL3JZNzQ0Q2g5WUhTT0lI?=
 =?iso-2022-jp?B?ZFJmRUVqa1RvQTNPWlpRSGFNbGJNdUFOSG5mbmZETVNIVHo4ZVdlZ3c2?=
 =?iso-2022-jp?B?V0lKQmFNOXdZVy83aUJoV0FKUzlhZzNydlUxbUFUUGtZMGVHRDhyTkEw?=
 =?iso-2022-jp?B?RDdMTklWaml0UkJJR2ZMcGtPNmI4Vmo2OUhmMzFKVS9HQ25CcFNvM1dW?=
 =?iso-2022-jp?B?a1EvL0d2ZFp4QWQvY0tqMG5IRnVnMDdqWEVmVkhSaUFsTlN4YmhKaUM2?=
 =?iso-2022-jp?B?dzlQb3hlNXpNcjFTTXBtMkhrTWFlRUsrM2tueFlTbWJsKzBBRFZvMDlP?=
 =?iso-2022-jp?B?eldjeFdjaHp2VzJ0M1NrUFJRMEtBOXRtaGM4dzJkeHVrMXNoNnpVN0Jv?=
 =?iso-2022-jp?B?T2hYQisyTFhrVllya25ZNEYyYnJCTUNiUUE9PQ==?=
Content-Type: text/plain; charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: 
	tLF05Je2s1awbG1csWNGT0TP9wXwXFGp4R5m18J6GcWY2SKZk8CGqA05g9EvjiSQucuSKin1BewuYDa56eerJ/FoYKdweoX3S4xHfKZjgVfhvd4gbcl5nmEHNYQQpPv48L0pTD/xI02WMN5wPVu9HY+OOUNQtE+edCV6UkqAICB/MgIxxQtUgEiiuCkzgUIyq2x4W4evuMzAYGoTMDeDUYPy03TgVkby8Csb1cWxTKfK++VfedtIMt9UtH7IGFN/gwixm+PJR6AXCFULklOF8H/M47xZM8CnzMXVMnLsrMnHxWfITD6e8/7VnG3RYcPRK9hIdPj8r8mqZjwgN6YZ5zNTXpOwyqN8DDtNNbq99ivCsPCg/cNfpQJWBz0TktFFvrs2K5mUYrPCH6XlI5PvNVfCeOadQwxjoJF6ANvbidKKwZdoL/D8p49ZqsBUaTV4vnqYtscliriBK+mO5A8x63Zf2aa9LFfiuz1M4wZotcSuXuuxEZ0mkfYfaNLIeT30aGE2fosnnmXKGNcgg/qzumFSU6ftEwyQPAx81+ntYE9sbAnyli0inudXmkdyV1snrga2mIGHIm7kyfK5cBzmBiDy++ZVXpMo6e2woFaofKAau3uhzZX+cLz+0lPJOYEJ
X-OriginatorOrg: fujitsu.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: OSCPR01MB14966.jpnprd01.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 0ccd7510-59d8-42b5-cab8-08de047bf00c
X-MS-Exchange-CrossTenant-originalarrivaltime: 06 Oct 2025 01:59:08.7474
 (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: 
 /SeDuVj/a6YgmF/v5c6T1Moetv3f6w6QNwf2Xq1NhfbsuP843nXT/O5XeubD+43uT8iianF2PTHW5bAX29D/hzb4Mht7ouc5UcmkE2vzIUU=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: OSCPR01MB13085
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/OSCPR01MB149662AEA64F4E66F494C2584F5E3A%40OSCPR01MB14966.jpnprd01.prod.outlook.com>
Precedence: bulk

Dear Iwata-san,

>Background
>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>If the background workers connect to databases, some database-related comm=
ands
>like ALTER DATABASE RENAME and ALTER DATABASE SET TABLESPACE cannot be don=
e.
>Users must do DROP EXTENSION related with workers, or terminate them by th=
emselves
>if they want to drop or alter the database.
>
>Proposal
>=3D=3D=3D=3D=3D=3D=3D=3D
>Based on above, I would like to propose to terminate background workers au=
tomatically
>when such SQLs are executed.
 >
>This feature allows the DBMS daemon to send a termination signal to backgr=
ound workers
>created by users currently operating on the database when executing comman=
ds that make
>significant changes to the database.

Per my understanding, we already have a facility that terminates a backgrou=
nd
worker, TerminateBackgroundWorker(). So, I'm afraid your proposal has alrea=
dy
been done by combining this function and ProcessUtility_hook.

So, is the main benefit of the patch to shorten extensions codes which uses
bgworker?

Best regards,
Hayato Kuroda
FUJITSU LIMITED