Feedback-ID: i0fe9450f:Fastmail
Date: Thu, 16 Oct 2025 12:37:01 +0900
From: Michael Paquier <michael@paquier.xyz>
To: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Cc: 'Andrei Lepikhov' <lepihov@gmail.com>,
	pgsql-hackers <pgsql-hackers@postgresql.org>,
	"Aya Iwata (Fujitsu)" <iwata.aya@fujitsu.com>,
	'Chao Li' <li.evan.chao@gmail.com>,
	Peter Smith <smithpb2250@gmail.com>
Subject: Re: [PROPOSAL] Termination of Background Workers for ALTER/DROP
 DATABASE
Message-ID: <aPBoXXW3XuwiIsHG@paquier.xyz>
References: 
 <OSCPR01MB14966B98E5119EBB261024ED2F5EEA@OSCPR01MB14966.jpnprd01.prod.outlook.com>
 <aOctHMnSZcREh0BR@paquier.xyz>
 <OSCPR01MB1496614832F8014EC16FB78D2F5EEA@OSCPR01MB14966.jpnprd01.prod.outlook.com>
 <aOc7_JGErxvqBLMP@paquier.xyz>
 <OSCPR01MB14966EC12277712131EB8EDF1F5EEA@OSCPR01MB14966.jpnprd01.prod.outlook.com>
 <OS7PR01MB11964C8FE9CDCC0F4C9110988EAEEA@OS7PR01MB11964.jpnprd01.prod.outlook.com>
 <E8C35CCE-E92F-467B-A604-5C1BBBA8F1C8@gmail.com>
 <OS7PR01MB11964C077A3E61F4887DD3D09EAEFA@OS7PR01MB11964.jpnprd01.prod.outlook.com>
 <43160fac-0c75-4e43-8894-2e1131075127@gmail.com>
 <OSCPR01MB14966350CC05D5AD0D339F60DF5EBA@OSCPR01MB14966.jpnprd01.prod.outlook.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="SnwFsJRBcF73JEja"
Content-Disposition: inline
In-Reply-To: 
 <OSCPR01MB14966350CC05D5AD0D339F60DF5EBA@OSCPR01MB14966.jpnprd01.prod.outlook.com>
Archived-At: 
 <https://www.postgresql.org/message-id/aPBoXXW3XuwiIsHG%40paquier.xyz>
Precedence: bulk


--SnwFsJRBcF73JEja
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Tue, Oct 14, 2025 at 04:36:01AM +0000, Hayato Kuroda (Fujitsu) wrote:
>> The only question I have is whether to
>> make sending a termination signal a default behaviour and let the flag
>> deactivate it.
>=20
> I think it can be done in future enhancement.
> We can change the default behavior based on the feedback from developers.

Yeah, I cannot agree with a change in the default behavior to cancel
the workers on a database touched by a database command.  This is a
behavior that exists since bgworkers are supported in tree in 9.3.  If
one is interested in making the workers more responsive, they could
just flip the flag switch.
--
Michael

--SnwFsJRBcF73JEja
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmjwaF0ACgkQnvQgOdby
QH3pmA//XW7gDkXi3q2yX1Dt5I2YpKMnE69lHaAOEpcQXz1sKK6VbXtg0Y7rBI/z
zQEYELG0uFMo4Gsi1trCiBSpnZS1Hly0RAnmHp/CgMt8i/6tuXBOoItMWIZbsAsh
tnMYivdGwoTrVd/o9kRBmKbJPwVrd1uc4YrakreUPZahnM0QTDcDSRtAO2t075su
1BZoF5BWD2+08T7r6UAvr0NKfoBvbHK5ZC5EUYdGHVc4SV2F76OqJYgV2gF+vW34
7SubvzyriaDceL/RI9tLfJ+yKZlKArm4ajG2L3WgauVUUmimAewbE/zFzRO9FQFO
rBWASO5No712pOT8e30Q+eApEg+w6vuds/vRHzAqscw054Pcw52I1PC90dwqnsxC
XE9TvpwoBsMuuA4dxEg7nVDSQpBZt8stGHSjbZe6thUHQC92rJ4wgToYW80vikmN
ZQUNVIxQyB/hp9zdmQOss1ffM+2HOxR/xT3jKb1OctmgQuJdNnWd7yBlRvBSlaaW
AyFzBsRTVec9j1LBWYgNYc9dtjNP+FAqUJLWos8vh09XopzTYYTVtg6zTgwCqwNV
PCpP5SceFPYnrA1b3LYk/BQHmostoTP+qHbA2TIcCQ5uB1GJ5Ww6lpahTtFWIgOG
f/TH13JGY+yEbmi3Jd9Vytg2e98hQb/exL+oVGhJ+fNAXLX05Ug=
=bIDD
-----END PGP SIGNATURE-----

--SnwFsJRBcF73JEja--