이상원 <swlee.kioplo@gmail.com> writes: > The Postgre database does not respond intermittently, causing a connection > timeout in the Spring Framework. There is no regularity in the occurrence > of connection timeouts and they do not repeat continuously. Not easy to > track.
I'd try turning on statement logging, and maybe also statement duration logging, and then matching up the times of observed client-side outages with what's happening according to the postmaster log. Connection and disconnection logging might be useful too.
A likely bet about the root cause is an unreasonably short connection timeout in some network infrastructure between your client and the database server. That would manifest as both sides reporting that the other side disconnected (not necessarily at the same time, but for the same connection). If so, it could likely be cured by adjusting the database's TCP keepalive settings. But you ought to gather data first.
I would have to agree that it is very likely a network issue.
