RE: Timeout parameters - Mailing list pgsql-hackers

From Nagaura, Ryohei
Subject RE: Timeout parameters
Date
Msg-id EDA4195584F5064680D8130B1CA91C453F39CB@G01JPEXMBYT04
Whole thread Raw
In response to RE: Timeout parameters  (MikalaiKeida@ibagroup.eu)
List pgsql-hackers
Hello Mikalai-san.

> From: MikalaiKeida@ibagroup.eu <MikalaiKeida@ibagroup.eu>
> The main idea of my comment was to avoid handling logical errors ( "client-side
> timeout") in advance to the detection of network problems!!!!
> Therefore, I suggested setting "client-side timeout" greater of equal to the
> TCP_USER_TIMEOUT or note about it in the documentation.
I have caught up with your intension. You have a point! Thank you.

> I'm afraid to be mistaken but I think that when network is alive it means that OS
> does not hang.
> I think that it is a responsibility of the OS kernel to manage network connections.
> Keep_alive mechanism checks a network state by exchanging data between
> client's and server's OS kernels. I think the same procedure is used in
> TCP_USER_TIMEOUT mechanism. So, when keep_alive and
> TCP_USER_TIMEOUT say that network works correct, it means that kernels of
> client and server do not hang. On the other hand it does not guarantee that
> PostgreSQL server is not hang. "client-side timeout" should handle this problem
> when network problem was not detected.
Thank you for your kind explain.

Best regards,
---------------------
Ryohei Nagaura




pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Offline enabling/disabling of data checksums
Next
From: "Nagaura, Ryohei"
Date:
Subject: RE: Timeout parameters