node-pg-pool icon indicating copy to clipboard operation
node-pg-pool copied to clipboard

release should reset state of connection

Open daurnimator opened this issue 6 years ago • 1 comments

When a connection is released back to the pool, the connection should be reset to a clean state. This should probably be done by running

rollback;
discard all;

Alternatively/additionally, you should expose an event for a connection being added back to the pool. This would allow the query to be customisable.

Other pooling implementations have similar facilities, e.g. pgbouncer has the configuration parameter server_reset_query

daurnimator avatar Mar 14 '19 02:03 daurnimator

(Formerly brianc/node-postgres#391 – from when the pool was part of pg)

charmander avatar Mar 14 '19 13:03 charmander