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 CAPmGK14xQtN+Zg3-EUzO_--CBqjAyTh=LV4do9VjRQB2jWK7mw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: postgres_fdw: commit remote (sub)transactions in parallel during pre-commit  (David Zhang <david.zhang@highgo.ca>)
Список pgsql-hackers
On Tue, Nov 2, 2021 at 7:47 AM David Zhang <david.zhang@highgo.ca> wrote:
> Followed your instructions, I performed some basic tests to compare the
> performance between before and after. In my testing environment (two
> foreign servers on the same local machine), the performance varies,
> sometimes the time spent on RELEASE and COMMIT without patch are close
> to after patched, but seems it always perform better after patched. Then
> I ran a 1-millions tuples insert, 5 times average is something like below,
>
> Before
>      RELEASE 0.171 ms, COMMIT 1.861 ms
>
> After
>      RELEASE 0.147 ms, COMMIT 1.305 ms

Good to know!  Thanks for testing!

Best regards,
Etsuro Fujita



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

Предыдущее
От: Etsuro Fujita
Дата:
Сообщение: Re: postgres_fdw: commit remote (sub)transactions in parallel during pre-commit
Следующее
От: Etsuro Fujita
Дата:
Сообщение: Re: Commitfest 2021-11 Patch Triage - Part 1