RE: logical apply worker's lock waits in subscriber can stall checkpointer in publisher

Поиск
Список
Период
Сортировка
От Hayato Kuroda (Fujitsu)
Тема RE: logical apply worker's lock waits in subscriber can stall checkpointer in publisher
Дата
Msg-id TY7PR01MB14554D2AA402BAD298B480A2EF59AA@TY7PR01MB14554.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на Re: logical apply worker's lock waits in subscriber can stall checkpointer in publisher  (Fujii Masao <masao.fujii@gmail.com>)
Ответы Re: logical apply worker's lock waits in subscriber can stall checkpointer in publisher
Список pgsql-hackers
Dear Fujii-san,

> Yeah, but I'd like to try the first option. Attached is a very WIP patch that
> attempts to implement it.
> 
> With this patch, when a walsender exits with >= FATAL,
> send_message_to_frontend() attempts to send the error message to the standby
> in non-blocking mode. If that fails, the walsender gives up on sending
> the message and exits immediately.

I'm still unclear it is OK to modify the fundamental code, but confirmed your
patch can solve the issue.

One concern for me is that the WALs might be more likely to be missed for
streaming replication case. What if the case walreceiver is bit busy thus send
buffer becomes full for a while?
Are there no issues because switchover after the walsender exits with FATAL is
not recommended?

Best regards,
Hayato Kuroda
FUJITSU LIMITED


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