Re: postgres_fdw: commit remote (sub)transactions in parallel during pre-commit

Поиск
Список
Период
Сортировка
От Etsuro Fujita
Тема Re: postgres_fdw: commit remote (sub)transactions in parallel during pre-commit
Дата
Msg-id CAPmGK17EVR9ahCZXTxoQ1rF175s1f1EcHNoesKFKWKc5cWhchA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: postgres_fdw: commit remote (sub)transactions in parallel during pre-commit  (David Zhang <david.zhang@highgo.ca>)
Список pgsql-hackers
On Sat, Mar 12, 2022 at 10:02 AM David Zhang <david.zhang@highgo.ca> wrote:
> Applied patches v6-0002 and v6-0003 to master branch, and the `make check` test is ok.
>
> Here is my test result in 10 times average on 3 virtual machines:
> before the patches:
>
> abort.1 = 2.5473 ms
>
> abort.2 = 4.1572 ms
>
> after the patches with OPTIONS (ADD parallel_abort 'true'):
>
> abort.1 = 1.7136 ms
>
> abort.2 = 2.5833 ms
>
> Overall, it has about 32 ~ 37 % improvement in my testing environment.

I think that is a great improvement.  Thanks for testing!

Best regards,
Etsuro Fujita



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

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: Re: add checkpoint stats of snapshot and mapping files of pg_logical dir
Следующее
От: Etsuro Fujita
Дата:
Сообщение: Re: Defer selection of asynchronous subplans until the executor initialization stage