Hi, these are excellent advices, thanks. I’m pretty sure that these are not the issues though. I’ve already reduced risks for long running queries or idle connections by adjusting the configuration and setting low timeouts.
The first error was:
Server bk_db/pg1 is DOWN, reason: Layer7 timeout, check duration: 5001ms. 0 active and 1 backup servers left. Running on backup. 103 sessions active, 0 requeued, 0 remaining in queue.