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

On Tue, Nov 2, 2021 at 7:47 AM David Zhang  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