Re: Add a perl function in Cluster.pm to generate WAL

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Add a perl function in Cluster.pm to generate WAL
Дата
Msg-id ZZzSnBZ3-8zQ-OoC@paquier.xyz
обсуждение исходный текст
Ответ на Re: Add a perl function in Cluster.pm to generate WAL  (Alexander Lakhin <exclusion@gmail.com>)
Ответы Re: Add a perl function in Cluster.pm to generate WAL  (Bertrand Drouvot <bertranddrouvot.pg@gmail.com>)
Список pgsql-hackers
On Mon, Jan 08, 2024 at 08:00:00PM +0300, Alexander Lakhin wrote:
> Yes, I've added (VERBOSE) and also cut down the test to catch the failure faster.
> The difference between a successful and a failed run:
>         tuples: 1 removed, 15 remain, 0 are dead but not yet removable
> [...]
>         tuples: 0 removed, 16 remain, 1 are dead but not yet removable

Yep, it's clear that the horizon is not stable.

> With FREEZE, 10 iterations with 20 tests in parallel succeeded for me
> (while without it, I get failures on iterations 1,2).
>
> [1] https://www.postgresql.org/message-id/b2a1f7d0-7629-72c0-2da7-e9c4e336b010%40gmail.com

Alexander, does the test gain in stability once you begin using the
patch posted on [2], mentioned by Bertrand?

(Also, perhaps we'd better move the discussion to the other thread
where the patch has been sent.)

[2]: https://www.postgresql.org/message-id/d40d015f-03a4-1cf2-6c1f-2b9aca860762@gmail.com
--
Michael

Вложения

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

Предыдущее
От: Bertrand Drouvot
Дата:
Сообщение: Re: verify predefined LWLocks have entries in wait_event_names.txt
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: speed up a logical replica setup