• Fujii Masao's avatar
    postgres_fdw: Add functions to discard cached connections. · 411ae649
    Fujii Masao authored
    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
    411ae649
postgres-fdw.sgml 32.7 KB