News for hackers. Stuff that matters.
Re:The SQL layer in CockroachDB by bdarnell on Saturday April 22, 2017 @04:18PM (#14174518)
Ah, right. We did turn on TCP keepalives so we probably don't need a protocol-level ping (although we often deploy behind haproxy, so tcp keepalives need to be configured at each hop)
Re:The SQL layer in CockroachDB by anarazel on Saturday April 22, 2017 @04:59PM (#14174755)
Similarly, tcp level keepalive not necessarily sufficient, if there's intermediate "pgwire" protocol level connection poolers like pgbouncer. Nor do they protect against applications that are effectively hung somewhere.

So I do think "pgwrite" level pings make some sense, it's just not exactly straightforward to add them :/