Re: BUG #14973: hung queries - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #14973: hung queries
Date
Msg-id CAB7nPqTvp5JCXGwr5=zW-WGZOyNjR+yN2G_5Ew-ookBwKAA8Fw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #14973: hung queries  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-bugs
On Tue, Dec 19, 2017 at 4:02 PM, Amit Kapila <amit.kapila16@gmail.com> wrote:
> On Tue, Dec 19, 2017 at 2:48 AM, Dmitry Shalashov <skaurus@gmail.com> wrote:
>> Hi Thomas,
>>
>> I'm glad to help. Thanks for the advice!
>>
>> By the way, there was a mistake in my bug report - wait_event actually was
>> BgWorkerShutdown.
>
> I think BgWorkerShutdown type of wait event can be only for the master
> backend not for all the workers.

Yeah, that's what happens when calling
WaitForBackgroundWorkerShutdown() as the primary backend waits for all
the workers to stop. You can see it as well this wait event in a
logirep launcher by the way.
-- 
Michael


pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pg_restore --create --no-tablespaces should not issue 'CREATEDATABASE ... TABLESPACE'
Next
From: Ashutosh Sharma
Date:
Subject: Re: 10.1: hash index size exploding on vacuum full analyze