postgresql - Reuse persistent dblink connection -
We have a function that is often triggered and makes remote DB a query. If I am not wrong then the connection work is in the current call / session. Is it possible to make a global connection in a remote DB and reuse this connection on each connection call?
The person we are facing takes a query more than 1 to transfer only 3 records.
say:
until the connection has closed or continues The database session has expired.
Then this function is designed to be reused in calls. Just reuse it.
Comments
Post a Comment