From: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
To: "Aya Iwata (Fujitsu)" <iwata.aya@fujitsu.com>, 'Michael Paquier'
	<michael@paquier.xyz>
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: Adw0Q6iYueu3o2DFQ0mAqFGMYYi8fgCHrYogAANaoAAADhfaoAAhDAPQ
Date: Tue, 7 Oct 2025 02:00:18 +0000
Message-ID: 
 <OSCPR01MB14966CBEA1C4F5967ABEE6AEAF5E0A@OSCPR01MB14966.jpnprd01.prod.outlook.com>
References: 
 <OS7PR01MB11964335F36BE41021B62EAE8EAE4A@OS7PR01MB11964.jpnprd01.prod.outlook.com>
 <OSCPR01MB149662AEA64F4E66F494C2584F5E3A@OSCPR01MB14966.jpnprd01.prod.outlook.com>
 <aOM02tVFtXmuR0M1@paquier.xyz>
 <OS7PR01MB119648846BA926C096CE016B6EAE3A@OS7PR01MB11964.jpnprd01.prod.outlook.com>
In-Reply-To: 
 <OS7PR01MB119648846BA926C096CE016B6EAE3A@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=43fd3c40-c43f-4af8-a6c4-97020f01f91f;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-06T10:01:17Z;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_|TY7PR01MB16838:EE_
x-ms-office365-filtering-correlation-id: 14d0e74c-e46e-48a7-c309-08de05454414
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?R1R2WFdweDdTNTlxcUJrUFhxVFRGNnhuQ1hydXFIemJPTWUxaHRvMDFY?=
 =?iso-2022-jp?B?cEN1MHdNZGFGVk40V00ybis0UUNXVnZqbWx6d1hzQ0J6anBveUZrclFU?=
 =?iso-2022-jp?B?bXpDclJ1ejlacVdtSzIzRE1RN3BnMXhNRlNTcXd0VitreHlpNnk3MGww?=
 =?iso-2022-jp?B?RTgwc2hhMGw1NlQvNXdMbWVOK1FyYWpJdFgxQk5sbEViQjdHa3RFc1k5?=
 =?iso-2022-jp?B?OWFVS2FUQ1A5TXBueDVJcDlpaGpzTG82aWtNdXExbitQTFAvS1ErVmIw?=
 =?iso-2022-jp?B?eERqamZvbDI3YVVLRDZWdzcyTm1FOUMycUl3V0Z1VURlTWt4M2dKS0J6?=
 =?iso-2022-jp?B?M3lOMXAxZDVWNkVYKzNXdW1Kcmw4UDJkS0tISXZRMVltanRzSmc4Yy9i?=
 =?iso-2022-jp?B?Q1VCSkVlaTJYYmVQZndidjhuZ1FwOGdjM1BDdG5DQ0NkM3ozS2svdmtW?=
 =?iso-2022-jp?B?QjNkSGg1ZFlhTG1WZHRyYWlIOCtrMDFRcEk1c1A5NGxpdmIvMktjZFkw?=
 =?iso-2022-jp?B?UTdGYW16Rk5oRTZWY3lwODZQeWRtcFBqZHB3L25ob0pzbDYyVUcwbWNl?=
 =?iso-2022-jp?B?Q0kwZjVOS0dqcWVRWWZJa2ZkTDViZC9rd051TnpOQlFqaGI3ekd3aHY2?=
 =?iso-2022-jp?B?Wjc5TllEdEdMcVFyNjZOQWFTUGR6bjlyVC9ubkt6WDg4K29TM1I2clEr?=
 =?iso-2022-jp?B?QS9jU2hhRm83OTVpeEx3cThDdVA1T0RNbng5MER5THV6OW5jVWNNK3Bk?=
 =?iso-2022-jp?B?T0ZQZ01DVEowQjZrZ01keEx5V0x4Y21iT1Q2RkhEZThCdHFTSkRxVW1u?=
 =?iso-2022-jp?B?SEQ1NGxSVDJ2bUVqSmU4MlpUUHI1NEY0ZTBqbmUwQ1dQa1VJYUJZbFha?=
 =?iso-2022-jp?B?ZEkyNkRSaUtUbENuQVQrdGR3aGo1d2EyczNpamRob0JYZTIzVG4vOVA2?=
 =?iso-2022-jp?B?ZEVFanZmaG9EaFI0eVRaVGxOSmtFR0JJTyt5YXdwVjJMa1pWMjJ1eXVs?=
 =?iso-2022-jp?B?U0hNZGZxQzdhUTVTZlFHSG13dWh6eTdLb1pHakRlekt3dzZFNGJYenJu?=
 =?iso-2022-jp?B?VUtRMk9SbjRNbVhqb2pOaERXcTAyVnJXQWJ1aW1TNzJ5Yi9sUCtEc0Vr?=
 =?iso-2022-jp?B?dkZ5R3E2Z2F2aU1BeWFXS3NnMWJyd3ZoRy9Kc0hGbVIyVEhEUS9ic25D?=
 =?iso-2022-jp?B?OVZvWEtYRDZ3K0YyUWEwcVVxcG1FWTdWTTN4WXhsN09yaUtSalZOalBZ?=
 =?iso-2022-jp?B?THA3OFREY0pkUktJdkI3Vkx6VWVGWHBJbmRZcERyM2NPMTRmVXlhLzBu?=
 =?iso-2022-jp?B?b0lCM1p2b0FDSEhJM2lDc2pxS3ZnRHUzdWFLTnl0SkVTVnVRUXF0amdD?=
 =?iso-2022-jp?B?clcyajlta09tUUVRVVgyZ3dyZDNuRlowYmswZ1l1V2JKRDc3cHJzN3Bz?=
 =?iso-2022-jp?B?Vmc3dGt0QzhGZFY2N253cy9GQjQ1cHY2TzhzZ3l3S0JpQTByZlQ3ZVB5?=
 =?iso-2022-jp?B?UVVZa3NXcC9qc3I5NFdhWThyK0ZXQTRxTjVYZjQra3RFQ09FV0RNL3JS?=
 =?iso-2022-jp?B?NG85b280WWQwWTRHK3cxcE1URURvVDlGN0pET1l0UjcyQnFMQWJhaVdq?=
 =?iso-2022-jp?B?S0pNVzVKVXE1aVI4cEpHQUNTa0orM28rdVAwNytwM2VhNUcvSnc4MzRI?=
 =?iso-2022-jp?B?TFRDeGwxY0hEOHh4d1QvTDNGZlI4MHBBRDJhTVNycHI3NE84Y1dhdlk2?=
 =?iso-2022-jp?B?K1h4VDBsR1lKNVQyMDhqQUl2Vi9pSXZWbGdvdzE3NmdURnorSjJSWmgr?=
 =?iso-2022-jp?B?aWQ0OFBRNUw4NHlwellKenZrTUxRNVp6N3BNbU9SaVZ1eHpObzlidndv?=
 =?iso-2022-jp?B?bXlMcHpkTmx1WWNaQnh6T1pVNytSdE9jTU1ncHc5emFMR0QxcmZLaTVq?=
 =?iso-2022-jp?B?azZxWUxRS0xGSVZKc05zTjBUZy9yTGM5UW03dktPb0p2VnVrZlBvdmp3?=
 =?iso-2022-jp?B?YjRadU1QOTdabkFPT2dIaktJUXg3WSt0dElOVXpVemZHaFo4bm9qVGEz?=
 =?iso-2022-jp?B?QmJvMDV2WjZEV0FISHJEWmNLajVtY2hnK2VYVFFvTVU1QkZRNXNPY1d0?=
 =?iso-2022-jp?B?cXg3VW1NNHRZb1BYSGFEUFBJZUw0OWJWdVpsODM5WEpYQzhsbmE4ZFRy?=
 =?iso-2022-jp?B?RnFTYjlHa2FtNUhIdEYycnE3UWZrSS80QnljdlhiUDVHcHZpU2NGLzVV?=
 =?iso-2022-jp?B?V1p4QT09?=
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?Q0d2T0lIWlQyRzEwZ2FoeDRaa3VQSDdxUXowd2hUWmlrUlk1cDZyN09W?=
 =?iso-2022-jp?B?THhzWkg1Wk81UmRlZEErbDM3RUVoQ0xENkhXd2FSSVprRGVnYTlKYitQ?=
 =?iso-2022-jp?B?WTNXbUZWS3FPeDlmVzBuc2hPZUxIMWluMy9UdTBNUi9HbGJIN2hRYnJL?=
 =?iso-2022-jp?B?RERTZ2dBb294ZGkwWjcwc0ZueEdUTXZ4VDJpQ1VqL1lBNVFsMzNBZUpP?=
 =?iso-2022-jp?B?aHRBcGVjMnR0Z1hId0dYM2l4ZmlSSUE4V2UrelFKYmpYempqQ3I3Z09Y?=
 =?iso-2022-jp?B?U1Nta2hvYWxtZFFJNUh0UWNtUFQrMVFORmt3U0JpK2JYQVIzNGdkbk42?=
 =?iso-2022-jp?B?N0xRdXYrSzNNa0pLM05hV0dIMmVTQ2JMb0hGWmtsZ3QyZFNUaURaRCs0?=
 =?iso-2022-jp?B?d0RjdWRKQWFCWEdCdVNQUEY4L3N6TnNYRW9nVy82RG5aMjNPbE1Wd2hI?=
 =?iso-2022-jp?B?MjUzUXU3bU5ZaWhYRjhlUXVnMjhlQVBodE9hcStLbnlTWXh1MS9aSmZy?=
 =?iso-2022-jp?B?UVVyY2ZtWU00MnQ5SjJpdEZjR0ttdG5OV0pPUDhGa1BMMVJud00vclVu?=
 =?iso-2022-jp?B?Zmd3RHZ6bkFTY2tvdFJpN2hqd2NvUzFWZ2gwNG1WWk4vZmVibWl4czJI?=
 =?iso-2022-jp?B?VCtmUXVyQU1HU0VNdXdVTXJtNmNoMm0zaVV1Q3hnSng1NHo2NEptTGJT?=
 =?iso-2022-jp?B?ZndVZGFDb2g2c0cxUHpYQytmWWQ2OWJsZTBZd1ZGb2RUSUxxMDB1d3Jm?=
 =?iso-2022-jp?B?NUl6bkYrbXdEOWgyckVPaVltb0VzcTZXQWpaeFhpOWhWSHJXSE11Mllp?=
 =?iso-2022-jp?B?aDFQeElNT21abVg1WUFrb1Vtdm9halJMcjhLeXlZVmtNbnNKNGdqeHFL?=
 =?iso-2022-jp?B?ZU5VMEhsdXBFMUdOcW5yYUdrTWNyMFpWN0Z1NGNSVnBOdXlyZ1J1RHJu?=
 =?iso-2022-jp?B?bnJob3E2aVBuWTNHMjRTTTBDV3FPNGZlS2RSRHRySHFTWHFXN3pUdUxO?=
 =?iso-2022-jp?B?OFYvZjg5MjFVeDhCOFFiazNQNGhqajNJNTNveTlxR2NLSXhwcHpkbDJL?=
 =?iso-2022-jp?B?QVpNbis5emdsbFhwNGxTOFVMSTY4U3luMXpSZVdYdG9LWjlDb28vb1dE?=
 =?iso-2022-jp?B?d1luUStPYzN5Y2srUnlTTHpnVzhZdkw0UkdKeDlEM1ZXQ2VXWVMwMjdT?=
 =?iso-2022-jp?B?ODFleFYyK0c3MlR5Y2xLSXZubTVtSXlBSmh1aWZXbTlpT0dWbXVFaVNG?=
 =?iso-2022-jp?B?Ry93N0ExeERoa1dpMjlQa2FUWDZzUERyc2xyckMzME1Eb2hLOTBCQmJh?=
 =?iso-2022-jp?B?MFhzZjB2NDRzRm5zSTZsYUplNFBhS3l2MVZyYk1NdVBYSFdJdit0MDJ3?=
 =?iso-2022-jp?B?Tk9sY1hCUUZRYllJcTVqWVpUeFNTQnkzZ0pZNjIxOEFzd1ovUXZmYi9s?=
 =?iso-2022-jp?B?YVBvajV4dTk3bWpUMjFBOHVyQ2daK2VmcTNwN3JuZFVoRXU5NlFBdG9i?=
 =?iso-2022-jp?B?SWNlUXF2dHlLZUhTdEVjbjllTkIrYWhsS3ByUllWYWxoSXZmN05sckRp?=
 =?iso-2022-jp?B?UnpzTmVXNHJKMk9FWjNocXV1enFsZDFOQWx6Zm9iSFc2U0JlL0kwdUJt?=
 =?iso-2022-jp?B?TVZpVWtmSmtGaExDaW9vcHRCVFF3ZjlFZ2lpN0hnSFc4bzhXdWd6Nnh2?=
 =?iso-2022-jp?B?ZXN0dFR4d1hBU2pZbjJDc0NFQ2R6VGFQeUZSUUJHYlZvdEpyT0FkSDk3?=
 =?iso-2022-jp?B?cmNnYWlUcWd6N3gwY3AyNTJDR1ZYd1ZQVUdSL3ZFOEhTODZrUkVPLzNI?=
 =?iso-2022-jp?B?T3BURTBHZEs3bDMvUnFVTGQ5VXU0UmZIOWxKblowUVk3UzVZWkhneU1j?=
 =?iso-2022-jp?B?K2xhZ0xIZzU2ODBCYWt6eGxkQU4xeTNNTlMyMlNHK1o1dzZkVmphS2NK?=
 =?iso-2022-jp?B?NG9WaHBaUEpoWlNKeG9tNFUvK1VQVzdlak5jakxmay9UVkVPWXlQcEFI?=
 =?iso-2022-jp?B?TFJocXRTdzFHZkRpM3JYeWJXVU04MU5XWEFQRWEvMlNIR01EcnBLRjAz?=
 =?iso-2022-jp?B?R2lYN1F3UnduQ09MWTkrcy9YUWVuTU9FV1YzMGI4OUJDNmxodkpzUEt5?=
 =?iso-2022-jp?B?dGRjUTFFTTlsWWtOTnQvU2RwcS82aTlYZVVYOW5kMEJVYUUvMzJ5N2xC?=
 =?iso-2022-jp?B?MklWTVVxRzRQRGxlNzNMQXZROWVRSFF1citJSDFDUkl5UUhjcmExUTdI?=
 =?iso-2022-jp?B?V1pibU1nNDJMSkkxVVRqWGwweGNFMEl0cFF6MS9JSERiaUw2TWZSWUVU?=
 =?iso-2022-jp?B?Y21VcjNLWkpjZU1kb04xcWdqeVpoemRlQ3c9PQ==?=
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: 
	3LIXWHKDn6LFNbfYqz2BFGwwYNHGXEDF5byaZ8rk1sRsBUhrb0NQIJNiF9fh5JZbYprvKmYqQJYVvIGEeohxUKKKn70MmNO+Ays3NazHUOqwLmBpGarQ9avDfLh8MTuh29rPUjbEyAtU3oAkw5o5NC+wR5D/yXiTdVSSFML+CDiGcEUfvVQz9Y17oGYAQ07hxQjiu8zqoPuAc0KwLmXeNVMN5GX/iKpbDF2yQqujNo0jfcFhUP85dIDGe3pWyLxo0bp+e2ygWgc8exM95dz0JnFlND9gMTn9kzEvOb358ThVVXFymnIddID4KW6+k1DCrH7mm+UwZaJNR+urQ+fAbFlAlBZhJLEcEE/5y57BfCNKskVWNo3oNtelMSJSo3lp2d6x3hntoQG5WBrVqxxXLoNxFffeZbOhOPCAMkcCJimgcDfobg67rB1oxPUYzcITWZTD98oNYFzVNLn5VxLOj0owTl7OwYtvhlJQ0IPoH+pJph1lIndpeP5QG1mFyjl2HlZMkEbnGs5GvUe260QRNPXAyhy329M8yFC2zGx1wVcFcjLkkRKy6XWNFQGxUyhKsbekcp/5uOeXPK+HmZvzhHwQsueqK6p8dwc4EDeT8b8HAjw1iAq916krL2D4ybjf
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: 
 14d0e74c-e46e-48a7-c309-08de05454414
X-MS-Exchange-CrossTenant-originalarrivaltime: 07 Oct 2025 02:00:18.6148
 (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: 
 BQUyztmefS24+E4enncm+z8vQZlG5LdDwz7XMCkYAFhirOecl5lBEX8Uf98032wAGFl9cC3Ht93BZvbjAiJTopzsCrYz/ZSj/tc0eaXwURk=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: TY7PR01MB16838
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/OSCPR01MB14966CBEA1C4F5967ABEE6AEAF5E0A%40OSCPR01MB14966.jpnprd01.prod.outlook.com>
Precedence: bulk

Dear Iwata-san,

Thanks for updating the patch.

> I updated my patch using bgw_flags to set whether accept to terminate bgw=
orker
> or not.
> And I also removed AcceptBackgroundWorkerCancel() function.
> Please check my attached patch.

```
+/*
+ * Cancel background workers.
+ */
+void
+CancelBackgroundWorkers(Oid databaseId, int cancel_flags)
```

Do we still need the cancel_flags? I cannot find other reasons to terminate
workers. Also the things I don't like is that BGWORKER_CANCEL_ADMIN_COMMAND=
S must
have the same value as BGWORKER_EXIT_AT_DATABASE_DROP. Only one flag exists=
 but
it has 0x0004. Can we remove the argument and flags from the patch?

[1]: https://www.postgresql.org/message-id/OSCPR01MB149662AEA64F4E66F494C25=
84F5E3A%40OSCPR01MB14966.jpnprd01.prod.outlook.com

Best regards,
Hayato Kuroda
FUJITSU LIMITED