Re: Default client_connection_check_interval to 10s on supported systems - Mailing list pgsql-hackers

From Tristan Partin
Subject Re: Default client_connection_check_interval to 10s on supported systems
Date
Msg-id CTEF7Y787TF4.1IIA8X5IXWWQJ@gonk
Whole thread Raw
In response to Re: Default client_connection_check_interval to 10s on supported systems  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri Jun 16, 2023 at 5:10 PM CDT, Tom Lane wrote:
> "Tristan Partin" <tristan@neon.tech> writes:
> > I am proposing that the default value of
> > client_connection_check_interval be moved to a non-zero value on
> > systems where it is supported. I think it would be a nice quality of
> > life improvement.
>
> I doubt that we need this, and I *really* doubt that it's appropriate
> to use a timeout as short as 10s.

Sure. Like I said, 10s is just a number pulled from thin air. The
original patches on the mailing list had this as low as 1s.

> One reason not to try to enable it by default is exactly that the
> default behavior would then be platform-dependent.  That's a
> documentation problem we could do without.

Totally fine with me if this is the reason for rejection. Just wanted to
put it out there for discussion since I don't think the original thread
covered the default value very much.

--
Tristan Partin
Neon (https://neon.tech)



pgsql-hackers by date:

Previous
From: "Tristan Partin"
Date:
Subject: Re: [PATCH] Missing dep on Catalog.pm in meson rules
Next
From: Quan Zongliang
Date:
Subject: Re: Incorrect estimation of HashJoin rows resulted from inaccurate small table statistics