Feedback-ID: i0fe9450f:Fastmail
Date: Tue, 17 Mar 2026 12:57:59 +0900
From: Michael Paquier <michael@paquier.xyz>
To: =?utf-8?B?S3Vyb2RhLCBIYXlhdG8v6buS55SwIOmavOS6ug==?=
 <kuroda.hayato@fujitsu.com>
Cc: =?utf-8?B?SXdhdGEsIEF5YS/lsqnnlLAg5b2p?= <iwata.aya@fujitsu.com>,
	Peter Smith <smithpb2250@gmail.com>,
	Pavel Stehule <pavel.stehule@gmail.com>,
	Chao Li <li.evan.chao@gmail.com>,
	pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: [PROPOSAL] Termination of Background Workers for ALTER/DROP
 DATABASE
Message-ID: <abjRR1bhoa9N8XEa@paquier.xyz>
References: 
 <CAHut+PvP6H2soK05c_0JZC8--=h4nWEtxYE_nJGjRkQr=25F1w@mail.gmail.com>
 <aVs3IpiYjmq3gLEn@paquier.xyz>
 <CAHut+PtSVYKU4vfaRev4FMdbeZ3ukvxRy4X7uK05jv_9WMYafA@mail.gmail.com>
 <OS7PR01MB1196426354C0294148A06AC65EA86A@OS7PR01MB11964.jpnprd01.prod.outlook.com>
 <CAHut+PtZh+B_-z_TzmToUhL4-sBrf7dfH0uAb7VU-jkXFmHQSA@mail.gmail.com>
 <aVyfvgMplnc6aIE2@paquier.xyz>
 <OS3PR01MB8889505E2F3E443CCA4BD72EEA45A@OS3PR01MB8889.jpnprd01.prod.outlook.com>
 <abev_E-SE94zHP0n@paquier.xyz>
 <abiUQ5MBGG9MDM1h@paquier.xyz>
 <TYRPR01MB12156CA129F54361D19ECAB56F541A@TYRPR01MB12156.jpnprd01.prod.outlook.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="uQYDHfOrj6iIh6g2"
Content-Disposition: inline
In-Reply-To: 
 <TYRPR01MB12156CA129F54361D19ECAB56F541A@TYRPR01MB12156.jpnprd01.prod.outlook.com>
Archived-At: 
 <https://www.postgresql.org/message-id/abjRR1bhoa9N8XEa%40paquier.xyz>
Precedence: bulk


--uQYDHfOrj6iIh6g2
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Tue, Mar 17, 2026 at 01:55:05AM +0000, Kuroda, Hayato/=E9=BB=92=E7=94=B0=
 =E9=9A=BC=E4=BA=BA wrote:
> I also had a discussion with her off-list, but I could not find neither.
> Additional idea is to increase the log level to make analysis easier, but=
 not
> sure what value is appropriate. Is it enough to raise to DEBUG1?

That would be an option.  Let's do that if we see another failure
after disabling autovacuum.  Another thing I have noticed is
debug_parallel_query=3Dregress for this animal, which may encourage
parallel workers, so I have also disabled it.  Let's see first if we
get more failures after af8837a10bc7.
--
Michael

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

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

iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmm40UcACgkQnvQgOdby
QH2O5A//d72YfsJcWgeEBq4wP939TMYA+oTxlaQRzf9ej11pQqVoojc6x0I0czDk
DGP5do6Cjgi+3vqLZ4CeCK5Kzdmp3OyEX1d+Z3a0hs0BuOB/+NmUf4DPZR9JRMco
VGT1wvg+R5rqMsqujwkwJCyxD4jVccCWWPzCGNkRw9nYJ0h36/TYofvwVXfuujnz
0r/+YXM1cwzdv8AVmu6x9PbIN4rpRNobVdeYSG9lypqk03pa/s3ufESWcQ1FH2Jz
yOJ/NS+zXXICnpTiILjQTb6hC1lUH9Pnd9CX4DqQJKL/4KXxAMQuLsNvm2beq5+S
J01PMD+20j07VozKn8a3DweS4ETyA08jWd225y5lGnHFARa34h2UaOwEsIEkJtrx
GwGnKPchum0xPtj3yVxTKu0jA0yplYFuzVxcB3j7MIvCkbq0sCifAPGJ0XSkyUbf
n3CPFTOvc9EMPecAe5qnD7MHJlM5+54RjLbXxC7HAijKJAbq/mhABqO4/kBgtv0M
9yJTWhvzdMo5+ipsvVb8qRuDdm8X5YBu1RD2jYOt1qb9KZIBdGRjqLN15tB6EBRq
vKsQs/oKs4x7QnAvnWD5+Gafkgq+AX0IrPT+pB9nYxrvEM+gJ85Vhi/nJ6JWYRqX
Ao1zdCMEcNx/XoR1mJzStaLAxlTTjybuXoXKkYhAfvZ1BJuZO+U=
=aT2X
-----END PGP SIGNATURE-----

--uQYDHfOrj6iIh6g2--