Re: pgsql: Use appropriate wait event when sending data in the apply worker

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: pgsql: Use appropriate wait event when sending data in the apply worker
Дата
Msg-id CA+TgmobWzbr9H3yN3dLVckviEZKemPwd+XyCFKEgyZQZhgP66Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: pgsql: Use appropriate wait event when sending data in the apply worker  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
On Mon, Feb 6, 2023 at 11:40 PM Amit Kapila <akapila@postgresql.org> wrote:
> Use appropriate wait event when sending data in the apply worker.
>
> Currently, we reuse WAIT_EVENT_LOGICAL_PARALLEL_APPLY_STATE_CHANGE in the
> apply worker while sending data to the parallel apply worker via a shared
> memory queue. This is not appropriate as one won't be able to distinguish
> whether the worker is waiting for sending data or for the state change.
>
> To patch instead uses the wait event WAIT_EVENT_MQ_SEND which has been
> already used in blocking mode while sending data via a shared memory
> queue.

This is not right at all. You should invent a new wait state if you're
waiting in a new place.

-- 
Robert Haas
EDB: http://www.enterprisedb.com



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Weird failure with latches in curculio on v15
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: AW: Wrong rows estimations with joins of CTEs slows queries by more than factor 500