Re: pgsql: postgres_fdw: Add functions to discard cached connections. - Mailing list pgsql-committers

From Fujii Masao
Subject Re: pgsql: postgres_fdw: Add functions to discard cached connections.
Date
Msg-id 68802f97-4eaf-ff8e-be3e-698cd4d50d28@oss.nttdata.com
Whole thread Raw
In response to pgsql: postgres_fdw: Add functions to discard cached connections.  (Fujii Masao <fujii@postgresql.org>)
List pgsql-committers

On 2021/01/26 15:37, Fujii Masao wrote:
> 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.


Hmm... this commit causes the buildfarm members to fail.
I'm looking at the issue.

Regards.

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION



pgsql-committers by date:

Previous
From: Fujii Masao
Date:
Subject: pgsql: postgres_fdw: Add functions to discard cached connections.
Next
From: Fujii Masao
Date:
Subject: pgsql: postgres_fdw: Stabilize regression test for postgres_fdw_disconn