Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vo381-00F1Fb-0W for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Feb 2026 17:26:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vo37y-000J2B-36 for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Feb 2026 17:26:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vo37y-000J23-29 for pgsql-hackers@lists.postgresql.org; Thu, 05 Feb 2026 17:26:50 +0000 Received: from mail-qv1-xf2f.google.com ([2607:f8b0:4864:20::f2f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vo37v-00000000iS1-2AiM for pgsql-hackers@lists.postgresql.org; Thu, 05 Feb 2026 17:26:48 +0000 Received: by mail-qv1-xf2f.google.com with SMTP id 6a1803df08f44-8947e6ffd30so13788106d6.0 for ; Thu, 05 Feb 2026 09:26:47 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1770312406; cv=none; d=google.com; s=arc-20240605; b=bur/eVyWtAYmgoo6WXIqttxFhmnfut0bQJP/nyb3B+waTDzjWVBmVqGKtzmvSYAmi/ mezjb4AJTiY6OYn1libFTuosCZnLtt2bNjJbuznDeIkGfeOmcQx/Pl6SccZsW9czcHfN dp+FhWkgax9HjjlhV2LHKOZycnm1WYzsG7QeM8aW31ohKve5V9rmt9fJINUS5eiNLWry BY9Ddy7Ngtq5DCkShzFBUcW93d+bFfW2z2V5hCIhuh23tC7enbZfeaKy0bjFhx7K8g/I zz1ZguPP7609xuJLNasTIxtFe74HP5MnsMp1l55fe0WetMP1qv2wkb0ieJKKPXVvpI5Q V9Tw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=So4xukENUsKx3xu4W9fZa2DZR6vqT5mgnKYZzkELW3c=; fh=SsQfXmshmObTfuyGX2+l6cnZtskTHngisnwN5LS3Yws=; b=NgnyaT00O+6+4gItGjO2QWoe0VY2HZT1Pa/cWXeju9BwdtP3wOLhX4hUmgJfiOSeqQ ZQLnVvk9ycZdmrRsp0MfEBRHZf3ayZinq01N4qCB2SGwUEMU9Ok77hrJk7MnTmGdWzji mOI4SDrqtKOA1koH2zm9YuaOWAuIZfuMtqafnyboLwAL2RmoW7etQ7wCfeipJfNf8A6o Jow6P35x24fB29QL4CQuUr9uA4Nu1HQyvEvsHDBEbmBfEMlrfksKInTdCeZ85B/S3I1F 1i1xcOK589rhwMmrBpf/LLAF0y88a7uVvU0CY5cyHn/u4UDqb/ZdXzoGyzdz4qWkwPyA 2ykg==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1770312406; x=1770917206; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=So4xukENUsKx3xu4W9fZa2DZR6vqT5mgnKYZzkELW3c=; b=ksWYlJoJnp5UmrIEubPY5NjUuG7mBeDlroqqWLr1ZfZFCfe/jGWGuv1dI5pcxl52lc ++GiktQ421RVvqKGTmQqQsi2IgDMpe/FYSAh5HCV4caOEb5or1glNKkC7yIqX/nuuxhJ LWJSr2+lvaRHzekFdWa4ae5T4bCL4YdtkHn5gpG9ch+H2EVKMIyw0S+4SIjYWKlBSAFJ TFAOCDka20L+WVN17m+NvonM5dQwMtEAH9+z7NSOVO6SOSYjz4Bngf5NcvPw3XdbJBmn sjz+k7TeqjluLowXCd0zpqLA2HOgfY/9AYGtDtyJZ+owgFpipfxYyYvnl9MLGjjsW4CU 8E2g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1770312406; x=1770917206; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=So4xukENUsKx3xu4W9fZa2DZR6vqT5mgnKYZzkELW3c=; b=bAPvs5F5QJdMDCD2MiN2p4/ur7YOgy53z58dCsYsgv3+NV8EYz2U2+4ULZPWxAmNYk QczJ3HJKorxtj1SbXarheWOk7RzOjCXAtol1q1YteI8vFxf9aIJ38UDJvLYpSRPtJMWw 42+kWgz6gH0lCmGP5i3dCbjZvLa8QRBhd7/vjRSfB1EAloT03IC/UUiEJNHPdqjTBMcz d1a6SMJK8boMICy1dvpwRU8YdkvCo0/0cJUH3UybXdg0RBDUMo2Ygs7Wwvl73ve57+Kb tReZFaKDFhFgIZMMsAryrVjr/PdH8qZwJEpuOTpoLRft1wA9NggulsWAHXC/+8MxhB4z u7wA== X-Gm-Message-State: AOJu0Yw4fzm71OTouezrre8jNCn6BtNtI8YCiAcwI2rzXridibkRI90E yfHd4Mz5nOVniP/p/uC9I8q321PXnrbM2KcsrBuTBVmy0idMH/hrV/vw7GO3VW2fYWw3MM96hln Kzweb3QLFaNaE+8GGsCJ7/+nZ6G1Lq4kfl10nZfNo X-Gm-Gg: AZuq6aKxQhuwPQNKkJY7qPaZmUUxKtjTbTTe/WFX5LDi8mFTwL4wTIiYELcZKocw+EJ VzFhemDmzBfgPNfF/n0RwDV0iqP/2Hgf9PrN73IbGlh2hh24WTH9ShtTmzNKlqrZGaDurMrbKkq sNOSsZ/2iychBYQn1YLMKAOJzsv3/6QngfkK41ZkrPzrt6pKZiYDfENg7GkO2mNxJWNIWLuCxAy 2pyLxFGB+LjLs5iuUz1PXuyK0lBjfLkiOAMwI/rt6YJB+3nyU32iil8NlGXyiq+IenjQHIF1w== X-Received: by 2002:a05:6214:27e4:b0:882:6d42:53a7 with SMTP id 6a1803df08f44-89522196632mr106312256d6.40.1770312406027; Thu, 05 Feb 2026 09:26:46 -0800 (PST) MIME-Version: 1.0 References: <20260204213032.15bab46b@ardentperf.com> In-Reply-To: <20260204213032.15bab46b@ardentperf.com> From: Jacob Champion Date: Thu, 5 Feb 2026 09:26:34 -0800 X-Gm-Features: AZwV_QiXCWG0nhMy9yqEne-4FUfMGzsEDsctnk8yWnHANF7f7iwFsaG-JePvWj8 Message-ID: Subject: Re: client_connection_check_interval default value To: Jeremy Schneider Cc: "pgsql-hackers@lists.postgresql.org" , Marat Buharov Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Feb 4, 2026 at 9:30=E2=80=AFPM Jeremy Schneider 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%3D3RbU61hnus5sL0BK= qEBsLw%40mail.gmail.com