Re: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Kuroda, Hayato/黒田 隼人 <kuroda(dot)hayato(at)fujitsu(dot)com>
Cc: Iwata, Aya/岩田 彩 <iwata(dot)aya(at)fujitsu(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE
Date: 2026-03-17 03:57:59
Message-ID: abjRR1bhoa9N8XEa@paquier.xyz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Mar 17, 2026 at 01:55:05AM +0000, Kuroda, Hayato/黒田 隼人 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=regress 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message zengman 2026-03-17 03:58:21 Re: SQL Property Graph Queries (SQL/PGQ)
Previous Message Amit Kapila 2026-03-17 03:25:30 Re: Skipping schema changes in publication