postgres_fdw: Add option to control whether to keep connections open

Enterprise / PostgreSQL - Fujii Masao [postgresql.org] - 2 April 2021 10:45 UTC

This commit adds a new option keep_connections that controls whether postgres_fdw keeps the connections to the foreign server open so that the subsequent queries can re-use them. This option can only be specified for a foreign server. The default is on. If set to off, all connections to the foreign server will be discarded at the end of transaction. Closed connections will be re-established when they are necessary by future queries using a foreign table.

This option is useful, for example, when users want to prevent the connections from eating up the foreign servers connections capacity.

Author: Bharath Rupireddy

b1be3074ac postgres_fdw: Add option to control whether to keep connections open.
contrib/postgres_fdw/connection.c | 33 ++++++++++++++++++++---
contrib/postgres_fdw/expected/postgres_fdw.out | 23 +++++++++++++++-
contrib/postgres_fdw/option.c | 4 ++-
contrib/postgres_fdw/sql/postgres_fdw.sql | 13 +++++++++
doc/src/sgml/postgres-fdw.sgml | 37 +++++++++++++++++++++++---
5 files changed, 101 insertions(+), 9 deletions(-)

Upstream: git.postgresql.org


  • Share