On Jan 25, 2008 10:02 AM, PostgreSQL Admin <[EMAIL PROTECTED]> wrote: > We are using this bad piece of the software that does not close > connections to the postgres server. Is there some setting for closing > dead connections? And not TCP/IP keep alive does not work.
If the TCP keepalive can't detect them as dead, how is something else supposed to? I.e. if a keepalive packet gets answered, then the connection isn't dead, something is still connected to it. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match