There are situations when applications keep the database connection for a long period of time. It seems to be not important. However, if this application makes many connections or there are several applications with such behavior — things are getting worse.
This article is not a tutorial. It describes possible solutions to this issue. As usual, I will be glad to hear any alternative solutions.