pgsql: postgres_fdw: Add functions to discard cached connections.

From: Fujii Masao <fujii(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: postgres_fdw: Add functions to discard cached connections.
Date: 2021-01-26 06:37:07
Message-ID: E1l4HyN-0001wS-6Q@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

postgres_fdw: Add functions to discard cached connections.

This commit introduces two new functions postgres_fdw_disconnect()
and postgres_fdw_disconnect_all(). The former function discards
the cached connections to the specified foreign server. The latter discards
all the cached connections. If the connection is used in the current
transaction, it's not closed and a warning message is emitted.

For example, these functions are useful when users want to explicitly
close the foreign server connections that are no longer necessary and
then to prevent them from eating up the foreign servers connections
capacity.

Author: Bharath Rupireddy, tweaked a bit by Fujii Masao
Reviewed-by: Alexey Kondratov, Zhijie Hou, Zhihong Yu, Fujii Masao
Discussion: https://postgr.es/m/CALj2ACVvrp5=AVp2PupEm+nAC8S4buqR3fJMmaCoc7ftT0aD2A@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/411ae64997dc3a42d19eda6721c581841ce2cb82

Modified Files
--------------
contrib/postgres_fdw/connection.c | 135 ++++++++++++++-
contrib/postgres_fdw/expected/postgres_fdw.out | 208 +++++++++++++++++++++++-
contrib/postgres_fdw/postgres_fdw--1.0--1.1.sql | 10 ++
contrib/postgres_fdw/sql/postgres_fdw.sql | 98 ++++++++++-
doc/src/sgml/postgres-fdw.sgml | 67 +++++++-
5 files changed, 505 insertions(+), 13 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Fujii Masao 2021-01-26 07:05:16 Re: pgsql: postgres_fdw: Add functions to discard cached connections.
Previous Message Tom Lane 2021-01-26 03:28:39 pgsql: Improve performance of repeated CALLs within plpgsql procedures.