From: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
To: 'Michael Paquier' <michael@paquier.xyz>
CC: 'Peter Smith' <smithpb2250@gmail.com>, "Aya Iwata (Fujitsu)"
	<iwata.aya@fujitsu.com>, 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: 
 Adw0Q6iYueu3o2DFQ0mAqFGMYYi8fgCHrYogAANaoAAADhfaoAAkABYAAAgFebAAHqlkgAAc+sDgABamIwAAB8zgcAAA2L7gAAJh2gAAAJsSIAABnF4AAACrZPA=
Date: Thu, 9 Oct 2025 05:47:49 +0000
Message-ID: 
 <OSCPR01MB14966EC12277712131EB8EDF1F5EEA@OSCPR01MB14966.jpnprd01.prod.outlook.com>
References: 
 <OS7PR01MB119648846BA926C096CE016B6EAE3A@OS7PR01MB11964.jpnprd01.prod.outlook.com>
 <CAHut+Pt4Tn1bQYCsYeUt_gtcSB-KOTtRB70SLghkpsjfKGsm7w@mail.gmail.com>
 <OS7PR01MB119642CFE4F4DCF7FBBD040BBEAE0A@OS7PR01MB11964.jpnprd01.prod.outlook.com>
 <CAHut+Pu-nxNice547eGEW2O3hdRcFbPYWF4HiqktZO19X3Ah-g@mail.gmail.com>
 <OS7PR01MB11964628A74081DFCA442CBADEAE1A@OS7PR01MB11964.jpnprd01.prod.outlook.com>
 <CAHut+PuuOKKW2oDT0Z8q+UXsiteS67j6G6075FC3aAxeR0cxHQ@mail.gmail.com>
 <OSCPR01MB14966FC50CFB457938763AE09F5EEA@OSCPR01MB14966.jpnprd01.prod.outlook.com>
 <OSCPR01MB14966B98E5119EBB261024ED2F5EEA@OSCPR01MB14966.jpnprd01.prod.outlook.com>
 <aOctHMnSZcREh0BR@paquier.xyz>
 <OSCPR01MB1496614832F8014EC16FB78D2F5EEA@OSCPR01MB14966.jpnprd01.prod.outlook.com>
 <aOc7_JGErxvqBLMP@paquier.xyz>
In-Reply-To: <aOc7_JGErxvqBLMP@paquier.xyz>
Accept-Language: ja-JP, en-US
Content-Language: ja-JP
msip_labels: 
 MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_ActionId=613976e0-6f61-4bd9-9eda-c11384bb6818;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-09T04:56:26Z;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_|OSCPR01MB14693:EE_
x-ms-office365-filtering-correlation-id: 780908fe-89a6-4313-3966-08de06f76195
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: 
 BCL:0;ARA:13230040|1800799024|376014|366016|1580799027|38070700021|3613699012;
x-microsoft-antispam-message-info: 
 =?iso-2022-jp?B?TDZjdjU4U2FsdTJlSzAxbjJQYSsrTEJIdGJlZW1JY2hFQ2JGeE9xVXcr?=
 =?iso-2022-jp?B?MTluK0xMRmVhZW9MS21USXlIdEZXME1tS0dyLzJ4bnZaUnVrK3h5UWI2?=
 =?iso-2022-jp?B?K1dlRDdibGhHWFgvTVIwWmZiOUJOcCtteGdxOUNKMzNEMUQ2S0RYZTlE?=
 =?iso-2022-jp?B?TkJZOXg3blZmY1hENE9Rc2Z1V1VmNDB2K0s4c0JaN1JQOXBaMHROMFRX?=
 =?iso-2022-jp?B?d1RmRnNEYzlqaWxhVEJIeUVKNmtFbUE2RXZ6QTJoSXczTVpVeEZmb2pr?=
 =?iso-2022-jp?B?TVk4bkdaSmQ5UVppeERzOFpScm1xQWsrMkoycGlpYSszaW53K0Y5MHZQ?=
 =?iso-2022-jp?B?Mno2TXhNYmZmYWJwbExHWTkyWExTTnBxN3MyM3BycVRxdjJuRVRUd0dk?=
 =?iso-2022-jp?B?dkFsWTY3YXA0SENWK1YxejZXR2Q0YXFLY0EyVDBqYlhkWTBkMXZNOUxv?=
 =?iso-2022-jp?B?Y0NqclRpZENMVjBYWU44cC9VaDNvWkRBWW5XdHhGbUQ0cnNzS3pJamh3?=
 =?iso-2022-jp?B?cEhCYU9XeFhST0xDVTNCZFc4V3B4V2JQN0lMZnhqcXk4a1J3cy84bmMw?=
 =?iso-2022-jp?B?KzJTMnBVc3BZdXV3RHo4aUNHejNqeW9way9yRWVDUEIrZWQya3krbG1F?=
 =?iso-2022-jp?B?ZlJUd1N2U3RlQ1hhQ29uSFZwdUFtMUJVSSsvN0RBS3FiTktVSGhYeFBa?=
 =?iso-2022-jp?B?eXBlZUoxNklPMnQ2WjE2RytVa1J0Q1ZUdzcwN0VURmNjK1lES1FCb0lh?=
 =?iso-2022-jp?B?WUZFQ3AxU25LSFU4dWlITzJRUlMyMDdGV0pnV25tMVp4YVcvZHZhZUpt?=
 =?iso-2022-jp?B?cXBjTlJWUlhQTUhpYVRIQVVBaEt2Z1R1TXJKT1NkS0tTUlAwWjlwV2lX?=
 =?iso-2022-jp?B?bThnNVpNTC8vTVpoTnNBVE96bVhHRTZReUZ1R2ROZm9lVy9ycTJtWGtX?=
 =?iso-2022-jp?B?KzVScUxQeHlQcXRSMlpqZ0xwVHFHZU1HVU9FQ2NNWURGNVNHVk5hOERD?=
 =?iso-2022-jp?B?a0NMSW43aWZLblFJMktEUVg5bld4TG5qZ2dIYVptek5NdS9YL1U2aWk2?=
 =?iso-2022-jp?B?bExmZlhKZmtySWp0VU5ic0ZvSm5tM01pSTlTVXBwcVByaGc5N2N3c3E0?=
 =?iso-2022-jp?B?UGNBY2UyWkFnTHpZaUtTblczRE15MzI1b3BpdE4yZFVIQXZEL1lvYi9M?=
 =?iso-2022-jp?B?K0hleG5SOFJCSHR3Ly81UHN0cEMrUFdVYi9USHZJKzJUcjljNUwyK0R4?=
 =?iso-2022-jp?B?UkxrRG5CUEc0SWRseklDN2JKY0dzdU82cFloUHhBOFFqWjlmUWg0Vmd6?=
 =?iso-2022-jp?B?bWFSY3Bzb0MvN1ZXN2NZY0FVbEkwdlA0U0kwUFlNc3JSd0NkdDVPdngy?=
 =?iso-2022-jp?B?bFlQVGtVZzJ5OHdicUtTWHJBSjlJbWd0c2FEdUtJcHNtM29IanY5V1VG?=
 =?iso-2022-jp?B?WkIyRE5sdHkzNVhNRkNHSGkzNFNjaTgrNnZmVTYzczBNcDZ6Q2xqcWxy?=
 =?iso-2022-jp?B?WWIwUWJmcmxsalF4ODZBMUdDZGkvRzJhVGs3eWNSRWxud2cvT1NkMWt6?=
 =?iso-2022-jp?B?NTJrUmM3aG83UXVJM2MreGhHUzc0SXFDeDVCNFhwdllpWG56VW5NSS81?=
 =?iso-2022-jp?B?YUVZb3preVlUd0lUS3kxV1ltZVI2ajVycFlHZ0E4WGtXaldWZlcxaGp6?=
 =?iso-2022-jp?B?eTlKdU9MMXFKR3MrOXd1U0FCZ3Jnb2RJaHUxUHhsN05acWNXOG1HVC9L?=
 =?iso-2022-jp?B?Y2trT3hmNVpUTXpYRG5BNEo1VElhcThHSXV6VHlGb2NlVnJ5TjEzR01h?=
 =?iso-2022-jp?B?Z3ZTeHl0QTB2cTJSRmRlMDFUQyt2WnZqL1FxbVd1QnJZNkJPMklwNnE5?=
 =?iso-2022-jp?B?UERXL0pwK1dFeFZwb0xOeDJyRFVnVmM0ZzZYQTkraUxjaGluS3BhSWhj?=
 =?iso-2022-jp?B?SGUxYTZGWElGM0crSmJoZmpMRk9UMG9ReGJQV2FhRWhMbUFLZm5BczBO?=
 =?iso-2022-jp?B?bWh3TGxtWnFrYVgrRGE2ZWloR1NjOEFCQ3VIUUhpM3M4VmlGY0t2YmYz?=
 =?iso-2022-jp?B?R2FRWmhRcmtXWDR3bm54THJVdmNQOEswZWxWZm5nTG5YTENxWUpRQUQz?=
 =?iso-2022-jp?B?U0U2Q3E3QVJFdHJaNEV6Uy82SFh4WFlodFBBM1pDZ00wWDhPcVhKTTVm?=
 =?iso-2022-jp?B?cnpZYlh0Ni84Ull0TEwyR2cxRmVQU0VjZy9WOUpPZmRFUjBieVJBVWxG?=
 =?iso-2022-jp?B?UmJCWkQwc2NDODFkWStDSnZ1UGpibjd4akI3R0JHM3p2WjBDc21LZVlE?=
 =?iso-2022-jp?B?UlYrbw==?=
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)(1800799024)(376014)(366016)(1580799027)(38070700021)(3613699012);DIR:OUT;SFP:1101;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-2022-jp?B?ckdWUmRBVk1wSmtqZDNrbzczTWJ3aXdTUWxDNHpUV3BXTjQ4SU1NckNh?=
 =?iso-2022-jp?B?TTd5b2lOQVd0d1NndmtEMG9ya3E5S2l4RnQ3YS9YYkV5UHg5K0xJb1VE?=
 =?iso-2022-jp?B?WVZUdmJqbWYyS1dlOVB3cXFOc2xCdEluMTdISW5ZSGE4Z0ZEcmF1T0NE?=
 =?iso-2022-jp?B?bUdWUGJmNndvSWhKd3RWVlBmQmtmMXlueHkrM1JnQmJoMVhSQ1lHOERZ?=
 =?iso-2022-jp?B?Y3RMbTVGSHY5ZHdPR3hYaDZkRVhtUkRjcDdUZTNrY2JaMUtTWFd6b0lu?=
 =?iso-2022-jp?B?djdoVnd5Wkk5YVpJREVlTERGK2VxT0ZuV0pjK2NjdFpZYWlQVzVvU3hh?=
 =?iso-2022-jp?B?OWNsTVNSS21jRFo0cGFNczB0QlZPSm5HWVRURVBXYVJlU1hlQi9PMk9W?=
 =?iso-2022-jp?B?b1lwYWhMMDJtU3k5Vk44QTZhOEoyeXg2c3NRWHVUcjhUQ2lNSVFhWERE?=
 =?iso-2022-jp?B?Y0dlaTBCUGVTNm5oTGh6UnJ5bHVnZ1ZYZFZJMjRmN2VscHZVN1JaVGhI?=
 =?iso-2022-jp?B?a1QwVmJXS3YvWEErM1NBbkRNUTc4QkxJVEJyc241S1E3Vng0ZVFiOE9T?=
 =?iso-2022-jp?B?SXJ3RC9nVVVLY0NIMHdWTzhxUTdidVhFQ09KbmFUSk92TzZDbXFueG9u?=
 =?iso-2022-jp?B?bzBSU2R5MXgwTTBMK2xWWmJ2OXVvS1hMbDdqNU9MSXFXMm1mRTdnYlRO?=
 =?iso-2022-jp?B?ZUtVSVdFQkVJL0lFTnhvaDhEemZRd3FXUWdOQTFWWkFQUUxkdDhlc28w?=
 =?iso-2022-jp?B?Q3Q3MHA2K3diWHQzVzNNVDh6M3NmemNCeVVYMGhqZ25vNlFNVnFuY0V2?=
 =?iso-2022-jp?B?OWJ2YlRpWldYdzNhNEExRTgzaFJPNWNMK25iT2t0L0ZrVEdiUnpRcE1t?=
 =?iso-2022-jp?B?RmZnZXRUeS9XQmVuV1Y1QnFFTWRlanNOYTJXTnUyWnJMR2IvUEMwRnZ1?=
 =?iso-2022-jp?B?eWU5aU1aczBhVWdINXpNQU96OGpRd3ZZc1d5SzdsUHlCZkV4WFRWME9h?=
 =?iso-2022-jp?B?eW5UVDlRLzJjS0ZWb0ZRZjBoNTYxc3A4YXF1WkREeEl3VkF1OEovbXMw?=
 =?iso-2022-jp?B?TWdLTzY4VHp3QWYraUZzWENvUkNUODk2TUw4ZnlDWk9HL1NtTlpjSlFC?=
 =?iso-2022-jp?B?T0JzOW1IeWVlMUsxaFVwc0NnemIrQ0NqVlhVd0x0T3FXS1Boa3BoQjdG?=
 =?iso-2022-jp?B?YzVZejdxN203bE8vaE5ETEV1TGRUS1plc1dhbmNNbFJkZVhrTFBKcFBs?=
 =?iso-2022-jp?B?MXc5RE9kL21RclZRVGJDVzBsWmJCMGppWlN6ZW9ZSkR5QUxaaTNhS09S?=
 =?iso-2022-jp?B?eTIyTmNLVXlRVmVhcHRST3A0TG1zZ2NjSGE3eFFFSDJKclZ6SjJ2Z3V1?=
 =?iso-2022-jp?B?a3NUYUJ0M0pZVE5rZmlHbHhjUkhMWnpKWTY0dEFyZ2VGMDhzZy8rK2ll?=
 =?iso-2022-jp?B?ek0wK3kxSE9wMENYUzZtczNhTDhiMGdlOEVQaTFBWlhDWkdJM01uSUd2?=
 =?iso-2022-jp?B?emZrR3ZzeG1TdGppS3JaTW8vKzZEQTJGb3VsWENMNzR4ZEpDNCtWcEtx?=
 =?iso-2022-jp?B?aGEwUkRLRmpPbUNNZGdpSXQydDdkKzNKdG1PTGFGYTBPTnpIcnRiTmJx?=
 =?iso-2022-jp?B?L3VDTGhWdHpoNnhMc3dTNGV4WFg2eFNBb3YzQzg4bXpPWUMrUXF0bVc1?=
 =?iso-2022-jp?B?S3FnVm9CN1BFd3R5VHZjQmZOUzZmdDJ6SS91TmUwNmZMZ0RNQXJlQjEx?=
 =?iso-2022-jp?B?by9LNHk2cTR6SWZtRW5FM3VHNUVBZC83K2FPbVUxaWlaR09lVnl1NWI3?=
 =?iso-2022-jp?B?RXlubVd4M0hMTDczb1ZGbzJCd1VqODNwaEhTMVJqRms0YVZtTkJMZzhj?=
 =?iso-2022-jp?B?Q05OWHJMamhVT0lkL0E0cXJtLzJ6TUNpOGMybGxEbkxNMklFdUwyWWoy?=
 =?iso-2022-jp?B?T3QwdmNUSlZEa1U4K1NJWVhtOEVQTFB0WXpYSlI5RUdiQU9uOW41czcx?=
 =?iso-2022-jp?B?dU5yN1RZeDUrTWVzMHVQNDNNTWozSTFaMk0yRjZDTXZCcm43SlA2cnlt?=
 =?iso-2022-jp?B?RVNYSy9Vbnhvc0hwUjBmc0w5dUErTVg1ZmxtMDRwTUovcGtiWFViTEhL?=
 =?iso-2022-jp?B?eFdkWlg3dFpKRzZsdStkWVR2cGJkTHlLN2F6aUVTSlVlYis1Q2s2R2E4?=
 =?iso-2022-jp?B?QVE2d2F0TFVrd2R3eExpa0N0RFpucjBRaXVUVjVXUFYyQXF6VnY4NG1X?=
 =?iso-2022-jp?B?Y2tCU2JmMW9SdWVNcS8rbHQwNzlscURJQmJHV3Q3bnhjRWhjaXhJUUE0?=
 =?iso-2022-jp?B?czFkZ1RuWUZ2b2cxaDBTd3BTc2l2cDk3Ymc9PQ==?=
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: 
	nKPm2UXeFLoqd6F1XVBoN+eicT48A5Je0hqg1Sy1xA5dosLZbbiT3IA0P7zFWn9osCJLls0YDa9nEfMfRDyFR49lerC95ZHrdEkD0aKyrNR4Gl8w25n/nsf5CHmQTU0q/A7mEUAtZexuTkjwdn/9MB+RqWp3fFRkbfpXeILrXA9g5loZfRPt0YViF2rgBGiLbanHxWhsjNjIWMLWu1HSJmkBsSTGUAb5TSex+zOOJidVwC2XR0X8ADFPsL+XUsXS7YT9gd3XMQ/fajQcj/oRnJXckrtT7kiNXeJDD9jUUeaeKjfuyOj6wT5GEU+xVdo/zT7QmvJzChLt0++kvu/bNTq48ugLhGeIXXojG3YYl1DB1Dizr3SnElXl9BKcXafDo4JTkJQ/bTpQb1aDKIOELe+0fjrLa3R2NO/c3eP5Hag9OsZ2ldOOwgl5FtWgmPEk6w9oIgMEK3XcYUnmb5hFYUHyXPOEb+4d/ColXmaHVKBLMysQ9uE0QYBL+HW5EtBQ2nwebMZf9qjqW4vSPx1tD5f+2DJveKpoWrHbM5ztGa84tTuTtdvVi0yyuy8AANrU0zEeFeAdx0/obnk+b0GzmMr6UWmNoyCdtufGgs5ZPYJdK0aPNyUmWwS3P24tiP3j
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: 
 780908fe-89a6-4313-3966-08de06f76195
X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Oct 2025 05:47:49.6802
 (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: 
 muaZTPRRJX6122j/6TYXfXmPwvFPi29r20WX/NZx50zXsDFZbuKcps84Y3JkPS7b8+yBNMlxgKOZeEknguVE3ZvkzsqSIvO/qDCsZ+62aJM=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: OSCPR01MB14693
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/OSCPR01MB14966EC12277712131EB8EDF1F5EEA%40OSCPR01MB14966.jpnprd01.prod.outlook.com>
Precedence: bulk

Dear Michael,

> However, could there be more to consider here?  Contrary to DROP
> DATABASE, where we require the drop to be done by the owner of the
> database (or a superuser), CREATE DATABASE has less requirements: it
> is fine for a role to create a database if they have the CREATEDB
> rights. If we allow bgworkers to be cancelled when the database they
> are connected to is used as a source, that may be disruptive, so we
> had better document precisely the behavior of the flag and what users
> should expect from it when set.

Actually, if the database is not marked as the template one, the user must =
be
owner of the source or superuser. Not sure there is a real case that templa=
te
database has dedicated workers, but anyway I do agree to note down this beh=
avior.
It is surprising that creating other databases lead the process termination=
s.

Best regards,
Hayato Kuroda
FUJITSU LIMITED