RE: Timeout parameters

From: Jamison, Kirk [mailto:k(dot)jamison(at)jp(dot)fujitsu(dot)com]
> socket_timeout (integer)

libpq documentation does not write the data type on the parameter name line.

> Terminate any connection that has been inactive for more than the specified
> number of seconds to prevent client from infinite waiting for individual
> socket read operations due to dead connection. This can be used both as
> a force global query timeout and network problems detector. A value of zero
> (the default) turns this off.
>
> or
>
> Controls the number of seconds of connection inactivity to prevent client
> from infinite waiting for individual socket read operations due to dead
> connection. This can be used both as a force global query timeout and network
> problems detector. A value of zero (the default) turns this off.

The second one is better, but:

* Just "connection inactivity" (i.e. the application hasn't submitted any request to the server for a long time) does not terminate the connection.
* "due to dead connction" is not the cause for the timeout. If the timeout occurs, consider the connection dead (see keepalives_count).
* Not restricted to "read" operation?

Regards
Takayuki Tsunakawa