postgres_fdw: Add support for parallel commit.
Etsuro Fujita <efujita@postgresql.org>
postgres_fdw: Add support for parallel commit. postgres_fdw commits remote (sub)transactions opened on remote server(s) in a local (sub)transaction one by one when the local (sub)transaction commits. This patch allows it to commit the remote (sub)transactions in parallel to improve performance. This is enabled by the server option "parallel_commit". The default is false. Etsuro Fujita, reviewed by Fujii Masao and David Zhang. Discussion: http://postgr.es/m/CAPmGK17dAZCXvwnfpr1eTfknTGdt%3DhYTV9405Gt5SqPOX8K84w%40mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| contrib/postgres_fdw/connection.c | modified | +205 −18 |
| contrib/postgres_fdw/expected/postgres_fdw.out | modified | +77 −1 |
| contrib/postgres_fdw/option.c | modified | +2 −0 |
| contrib/postgres_fdw/sql/postgres_fdw.sql | modified | +46 −0 |
| doc/src/sgml/postgres-fdw.sgml | modified | +46 −0 |
Documentation touched
Discussion
- postgres_fdw: commit remote (sub)transactions in parallel during pre-commit 46 messages · 2021-10-31 → 2023-04-06