Francisco Olarte <folarte@xxxxxxxxxxxxxx> writes: > On Wed, Apr 17, 2019 at 4:49 PM Ajay Pratap <ajaypratap@xxxxxxxxxxxxxxxx> wrote: >> Correction: I meant when my java application dies postgres should break all the connections that were associated with that peer. > And how is the server supposed to detect that without keepalives? TCP > is dessigned to survice for extended period of times without traffic, > I used that a lot in the dial up times. > And what makes you think keepalives are impactful and unrealistic? I > use them a lot, they do not impact my workloads measurably. If we tried to do something about that in the server code proper, we'd basically be reinventing TCP keepalives --- probably badly. And we couldn't do it at all without a protocol version break, because the client-side code would also need to know about it. Just use the keepalive facility. regards, tom lane
