Re: tcp_keepalives_idle ignored

"henry" <henry@zen.co.za> writes:

> tcp_keepalives_interval and tcp_keepalives_count I have left on default.
> After a few hours worth of running, theres a few thousand idle postgres
> procs, and they're all idle...

Are you sure the clients are actually gone? tcp keepalives are only going to
help if you have clients disappearing -- such as networks being unplugged or
client machines getting turned off. Under normal conditions when a client
disconnects the postgres process will go away immediately.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's 24x7 Postgres support!