Re: [HACKERS] Walsender timeouts and large transactions

Поиск
Список
Период
Сортировка
От Petr Jelinek
Тема Re: [HACKERS] Walsender timeouts and large transactions
Дата
Msg-id 86acff25-ca5d-1dc0-2da7-006344021f06@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Walsender timeouts and large transactions  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
Ответы Re: [HACKERS] Walsender timeouts and large transactions
Список pgsql-hackers
Hi,

On 17/11/17 08:35, Kyotaro HORIGUCHI wrote:
> 
> Moving around the code allow us to place ps_is_send_pending() in
> the while condition, which seems to be more proper place to do
> that. I haven't added test for this particular case.
> 
> I tested this that
> 
> - cleanly applies on the current master HEAD and passes make
>   check and subscription test.
> 
> - walsender properly chooses the slow-path even if
>   pq_is_send_pending() is always false. (happens on a fast enough
>   network)
> 
> - walsender waits properly waits on socket and process-reply time
>   in WaitLatchOrSocket.
> 
> - walsender exits by timeout on network stall.
> 
> So, I think the patch is functionally perfect.
> 
> I'm a reviewer of this patch but I think I'm not allowed to mark
> this "Ready for Commiter" since the last change is made by me.
> 

Thanks for working on this, but there are couple of problems with your
modifications which mean that it does not actually fix the original
issue anymore (transaction taking long time to decode while sending
changes over network works fine will result in walsender timout).

The firs one is that you put pq_is_send_pending() in the while so the
while is again never executed if there is no network send pending which
makes the if above meaningless. Also you missed ProcessRepliesIfAny()
when moving code around. That's needed for timeout calculations to work
correctly.

So one more revision attached with those things fixed. This version
fixes the original issue as well.

-- 
  Petr Jelinek                  http://www.2ndQuadrant.com/
  PostgreSQL Development, 24x7 Support, Training & Services

Вложения

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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: using index or check in ALTER TABLE SET NOT NULL
Следующее
От: Robert Haas
Дата:
Сообщение: Re: using index or check in ALTER TABLE SET NOT NULL