postgres_fdw: Add option to control whether to keep connections open.
authorFujii Masao <fujii@postgresql.org>
Fri, 2 Apr 2021 10:45:42 +0000 (19:45 +0900)
committerFujii Masao <fujii@postgresql.org>
Fri, 2 Apr 2021 10:45:42 +0000 (19:45 +0900)
commitb1be3074ac719ce8073fba35d4c8b52fb4ddd0c3
tree4a7b836541eb0d7df10a6b83e951c7f9f673cc3e
parent9c5f67fd6256246b2a788a8feb1d42b79dcd0448
postgres_fdw: Add option to control whether to keep connections open.

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
Reviewed-by: Alexey Kondratov, Vignesh C, Fujii Masao
Discussion: https://postgr.es/m/CALj2ACVvrp5=AVp2PupEm+nAC8S4buqR3fJMmaCoc7ftT0aD2A@mail.gmail.com
contrib/postgres_fdw/connection.c
contrib/postgres_fdw/expected/postgres_fdw.out
contrib/postgres_fdw/option.c
contrib/postgres_fdw/sql/postgres_fdw.sql
doc/src/sgml/postgres-fdw.sgml