作者
digoal
日期
2021-01-26
标签
PostgreSQL , postgres_fdw
背景
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=411ae64997dc3a42d19eda6721c581841ce2cb82
```
postgres_fdw: Add functions to discard cached connections.
author Fujii Masao fujii@postgresql.org
Mon, 25 Jan 2021 18:54:46 +0000 (03:54 +0900)
committer Fujii Masao fujii@postgresql.org
Tue, 26 Jan 2021 06:35:54 +0000 (15:35 +0900)
commit 411ae64997dc3a42d19eda6721c581841ce2cb82
tree fd253810b075cc53cc2522b5bd55e2cf035abfd9 tree | snapshot
parent ee895a655ce4341546facd6f23e3e8f2931b96bf commit | diff
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
```
PostgreSQL 许愿链接
您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议，奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等，奖品丰富，快来许愿。开不开森.
9.9元购买3个月阿里云RDS PostgreSQL实例
PostgreSQL 解决方案集合
德哥 / digoal's github - 公益是一辈子的事.
