I am very new to Vertx, so please excuse me if this is a very basic question. I am facing issues with Vertx connection pool, I am using io.vertx:vertx-pg-client with Vertx version 4.2.7.
After sometime, application is not able to get a connection from the pool. We looked at a couple of metrics and we found vertx_sql_queue_pending high value aligns with the connection pool issue.
Why there are pending Jobs?
- Do I need to increase connection count?
- Any other resource which I need to increase to fix this issue?
Basically, I am not very sure what the exact issue is and how do I solve it.