RE: Timeout parameters

Hello, all.

> tcp_socket_timeout (integer)
>
> Terminate and restart any session that has been idle for more than
> the specified number of milliseconds to prevent client from infinite
> waiting for server due to dead connection. This can be used both as
> a brute force global query timeout and detecting network problems.
> A value of zero (the default) turns this off.

I am not very familiar with the PostgreSQL source code. Nevertheless, the
main idea of this parameter is clear for me - closing a connection when
the PostgreSQL server does not response due to any reason. However, I have
not found in the discussion a reference that this parameter can be
applied to the TCP as well as to the UNIX-domain sockets. Moreover, this
parameter works out of communication layer. When we consider TCP
communication, the failover is covered by keep_alive and tpc_user_timeout
parameters.

According to it, we should not use 'tcp' prefix in this parameter name,
'socket' sub string is not suitable too.

'timeout' is OK.

This parameter works on the client side. So the word 'client' is a good
candidate for using in this parameter name.
This parameter affects only when we send a 'query' to the pg server.

Based on it, we can build a name for this parameter
'client_query_timeout'.

The suggested explanation of this parameter does not follow the aim of
integrating this parameter:

client_query_timeout

Specifies the number of seconds to prevent client from infinite waiting
for server acknowledge to the sent query 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.

Best regards,
Mikalai Keida