Обсуждение: tcp_keepalives_idle
Hi, I am struggling to understand what following phrase says: tcp_keepalives_idle (integer) Specifies the number of seconds before sending a keepalive packet on an otherwise idleconnection. What I am not sure is the meaning of "otherwise". Can I safely replace it to: Specifies the number of seconds before sending a keepalive packet on an other side of idle connection. What I try to want to mean here is, "other side" is frontend side connection point. Or I am completely misunderstanding? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp
Tatsuo Ishii <ishii@postgresql.org> writes:
> I am struggling to understand what following phrase says:
> tcp_keepalives_idle (integer)
> Specifies the number of seconds before sending a keepalive packet
> on an otherwise idle connection.
It means "the connection is idle except for keepalive packets".
We could perhaps just drop the word "otherwise", if people find
it confusing.
> What I am not sure is the meaning of "otherwise". Can I safely replace
> it to:
> Specifies the number of seconds before sending a keepalive packet
> on an other side of idle connection.
No, that's not a good fix.
regards, tom lane
> Tatsuo Ishii <ishii@postgresql.org> writes: >> I am struggling to understand what following phrase says: > >> tcp_keepalives_idle (integer) >> Specifies the number of seconds before sending a keepalive packet >> on an otherwise idle connection. > > It means "the connection is idle except for keepalive packets". > We could perhaps just drop the word "otherwise", if people find > it confusing. Wah. I seemed to completely misunderstand what the pharase says. Thanks for clarification. I agree to drop "otherwise". >> What I am not sure is the meaning of "otherwise". Can I safely replace >> it to: >> Specifies the number of seconds before sending a keepalive packet >> on an other side of idle connection. > > No, that's not a good fix. Sure. I was absolutely misunderstood. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp
On 11/14/13 7:08 AM, Tatsuo Ishii wrote: >> It means "the connection is idle except for keepalive packets". >> We could perhaps just drop the word "otherwise", if people find >> it confusing. > > Wah. I seemed to completely misunderstand what the pharase > says. Thanks for clarification. I agree to drop "otherwise". I had some problem interpreting these explanations as well: http://www.postgresql.org/message-id/527A21F1.2000408@joh.to Compare that to the description in the libpq documentation: "Controls the number of seconds of inactivity after which TCP should send a keepalive message to the server.". Regards, Marko Tiikkaja
On Thu, Nov 14, 2013 at 11:32:23AM +0100, Marko Tiikkaja wrote: > On 11/14/13 7:08 AM, Tatsuo Ishii wrote: > >>It means "the connection is idle except for keepalive packets". > >>We could perhaps just drop the word "otherwise", if people find > >>it confusing. > > > >Wah. I seemed to completely misunderstand what the pharase > >says. Thanks for clarification. I agree to drop "otherwise". > > I had some problem interpreting these explanations as well: > http://www.postgresql.org/message-id/527A21F1.2000408@joh.to > > Compare that to the description in the libpq documentation: > "Controls the number of seconds of inactivity after which TCP should > send a keepalive message to the server.". Good point. I have improved the server-side keepalive parameter descriptions to use the superior libpq text, with adjustment. Applied patch attached. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. +
On Fri, Mar 7, 2014 at 10:03:42PM -0500, Bruce Momjian wrote: > On Thu, Nov 14, 2013 at 11:32:23AM +0100, Marko Tiikkaja wrote: > > On 11/14/13 7:08 AM, Tatsuo Ishii wrote: > > >>It means "the connection is idle except for keepalive packets". > > >>We could perhaps just drop the word "otherwise", if people find > > >>it confusing. > > > > > >Wah. I seemed to completely misunderstand what the pharase > > >says. Thanks for clarification. I agree to drop "otherwise". > > > > I had some problem interpreting these explanations as well: > > http://www.postgresql.org/message-id/527A21F1.2000408@joh.to > > > > Compare that to the description in the libpq documentation: > > "Controls the number of seconds of inactivity after which TCP should > > send a keepalive message to the server.". > > Good point. I have improved the server-side keepalive parameter > descriptions to use the superior libpq text, with adjustment. > > Applied patch attached. Oops, now attached. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. +