Re: BUG #14973: hung queries

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: BUG #14973: hung queries
Дата
Msg-id CAB7nPqTvp5JCXGwr5=zW-WGZOyNjR+yN2G_5Ew-ookBwKAA8Fw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #14973: hung queries  (Amit Kapila <amit.kapila16@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: pg_restore --create --no-tablespaces should not issue 'CREATEDATABASE ... TABLESPACE'
Следующее
От: Ashutosh Sharma
Дата:
Сообщение: Re: 10.1: hash index size exploding on vacuum full analyze