Re: Isn't wait_for_catchup slightly broken?

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: Isn't wait_for_catchup slightly broken?
Дата
Msg-id 20220111062502.obh4gegzcaova5dk@jrouhaud
обсуждение исходный текст
Ответ на Isn't wait_for_catchup slightly broken?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Mon, Jan 10, 2022 at 02:31:38PM -0500, Tom Lane wrote:
> 
> So I think we need to fix it to capture the target WAL position
> at the start, as I've done in the attached patch.

+1, it looks sensible to me.

> In principle
> this might make things a bit slower because of the extra
> transaction required, but I don't notice any above-the-noise
> difference on my own workstation.

I'm wondering if the environments where this extra transaction could make
a noticeable difference are also environments where doing that extra
transaction can save some iteration(s), which would be at least as costly.



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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Skipping logical replication transactions on subscriber side
Следующее
От: Gurjeet Singh
Дата:
Сообщение: Patch: Code comments: why some text-handling functions are leakproof