On Tue, Feb 19, 2019 at 10:52:54AM +1100, James Sewell wrote: > I agree the use case is narrow - but it's also pretty critical.
Yeah.. > I suppose an in-core way of disconnecting idle sessions after x time would > work too - but that seems like a sledgehammer approach. Such solutions at SQL level need to connect to a specific database and I implemented one for fun, please see the call to BackgroundWorkerInitializeConnection() here: https://github.com/michaelpq/pg_plugins/tree/master/kill_idle So that's not the end of it as long as we don't have a cross-database solution. If we can get something in PGPROC then just connecting to shared memory would be enough. -- Michael
signature.asc
Description: PGP signature
