vertx-sql-client icon indicating copy to clipboard operation
vertx-sql-client copied to clipboard

Add to PgPool more options for connection handling

Open pavelber opened this issue 6 years ago • 1 comments

We are using thew new vertx reactive SQL client for our reporting microservice. Sometimes reports are very heavy and those queries run too much time and the microservice stucks

So I want to cut too long queries using some maximal query time. Also sometimes we get stale, old DB connections.

In c3p0, in another microservice I solve those problems by using datasource options lie

  1. Max connection age
  2. test query
  3. unreturned connection time out

Is it possible to add this functionality to PgPool?

pavelber avatar Dec 02 '19 10:12 pavelber

This is a much needed option! We are currently solving this in the application level by maintaining timers for running queries.

It will be great to have this natively supported in the client

nnevo avatar Dec 02 '19 11:12 nnevo