Re: client_connection_check_interval default value - Mailing list pgsql-hackers

From Jacob Champion
Subject Re: client_connection_check_interval default value
Date
Msg-id CAOYmi+nS69LiUExZF=gGZ+NJU-SCNQ59qJTiWtJw96cDdi9iSg@mail.gmail.com
Whole thread Raw
In response to client_connection_check_interval default value  (Jeremy Schneider <schneider@ardentperf.com>)
Responses Re: client_connection_check_interval default value
List pgsql-hackers
On Wed, Feb 4, 2026 at 9:30 PM Jeremy Schneider
<schneider@ardentperf.com> wrote:
> While a fix has been merged in pgx for the most direct root cause of
> the incident I saw, this setting just seems like a good behavior to
> make Postgres more robust in general.

At the risk of making perfect the enemy of better, the protocol-level
heartbeat mentioned in the original thread [1] would cover more use
cases, which might give it a better chance of eventually becoming
default behavior. It might also be a lot of work, though.

--Jacob

[1] https://postgr.es/m/CA%2BhUKGLyj5Aqt6ojYfSc%2BqSeB1x%3D3RbU61hnus5sL0BKqEBsLw%40mail.gmail.com



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Fix pg_stat_get_backend_wait_event() for aux processes
Next
From: Pavlo Golub
Date:
Subject: Re: Re[2]: [PATCH] Add last_executed timestamp to pg_stat_statements