Fujii Masao <[EMAIL PROTECTED]> writes: > Because 'idle in transaction' backends that don't terminate by tcp_keepalive > keep holding the lock.
If a backend has gotten to the point of being 'idle in transaction', then it's certainly exchanged data with the client, so TCP keepalive should work. I suggest you need to file a kernel bug report if it doesn't. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend