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 1vo9Yy-00FzeT-0Q for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Feb 2026 00:19:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vo9Yx-001SYT-0L for pgsql-hackers@arkaria.postgresql.org; Fri, 06 Feb 2026 00:19:06 +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 1vo9Yw-001SYK-2W for pgsql-hackers@lists.postgresql.org; Fri, 06 Feb 2026 00:19:06 +0000 Received: from mail-qk1-x72d.google.com ([2607:f8b0:4864:20::72d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vo9Yt-00000000lG4-2imZ for pgsql-hackers@lists.postgresql.org; Fri, 06 Feb 2026 00:19:04 +0000 Received: by mail-qk1-x72d.google.com with SMTP id af79cd13be357-8c532d8be8cso132142385a.2 for ; Thu, 05 Feb 2026 16:19:02 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1770337142; cv=none; d=google.com; s=arc-20240605; b=Ho/QJW50zd1W500naxlZWfaJliFrh4mciNjMCH0Eyza3S+Gn1/UgdfnduaQM4qarma OxvLU1AC3VjwWCd7uz+dGfDPL14zdv4BvgKYjWmFOVMEhpD3RP78eOwAp3feQOF1qWV1 7VVAkGUwBakpLeTNZF2GXZl1UzF7SiOSoeD+GtYnOf0nm93A6Zmq8c9bTwm1hXKqba1u LkNpOmSolQPiKjqeXy3PXOFk83AIrrGeq+xCSe8FRI1tivre/Quy/OLZ65tgObbAJ1WC U45WGV8Nn1NpONKxZQ7xucbMjiwat3EYopjIm0eHMKBG760WRZKi0f5ctCNID/gnpMEb fTrw== 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=tiWOcgXGBAVqfY+Nrnmkdguvk931Yiskaetzs553O0k=; fh=Tn9gD6vwZiNWYu2yGY1TvvWIAEDLgOkXpJA6xw62jz0=; b=E2C0SDDbggLyJo42Q+6QBLjfwTTN/SKIof/OiiIQF1OyMEdTiCFeYOaB5R5tS5eCyP jeAFUUmc9evhn0SgoJ8xGfmxKihSb0cUR7TEy7Hp8iGXRmCMQ65t4rt7A5BZGbSp42ys wMhR1sFBPUZ8If4BdhGANkTSVQgffvW/fhw7e86GKu/zXZ+T+vrJKFdsNK8wjmsepXlK t5VvURCLAw8epwTQvu9hPtIxl6awvlmRi/ucNLxf7INa0RTI/a4K5VjnS8ByOveXKxy1 l7gQ4VsY/6oEcCqb9SOlVA+YQo4WJ6a26wQHx+zMOusRG2hWPDrQInt7ZsaNnsBEUL2P kWlA==; 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=1770337142; x=1770941942; 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=tiWOcgXGBAVqfY+Nrnmkdguvk931Yiskaetzs553O0k=; b=T0rVeFOOAzbeTmiPWhkxfofTEVPMWR3kFZwwvFkVvFu2gyNTGLgkRptedDmuxxZ3MF SEL0To+t7ImiE8btFrnZHcIQ9xDrAn2D+210QXhO+xO8dXVKwh1eGKqmNM+ulr0EbDow wBaA369UaFoVVZSjSq6+JEkBD+VJoRfAiQzGYyplKodNnGRwpD2wjwRznOLy8KAUjQY9 P/M0qvDlo5cEotxwdK5idQSmFE3yoVMdb+0Su6Jzs7rTEpbvgu/HuL/MAtKbPHx9O5kL vVqlxLTUok17R/+XN7QrBDGIaY65PNe/aU5YZAuGeJ1I7eefxFZje4ywk4xwwWH3CYtJ lkXg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1770337142; x=1770941942; 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=tiWOcgXGBAVqfY+Nrnmkdguvk931Yiskaetzs553O0k=; b=DZhbY4n0VcSh7USiNK1IdKy4lBaCTmTqAxn2iSuF3rkYYwF3gUU0ndtIyXKBwPHwbl p4Su5vOwbuqLyczx2tiTKkerKJdZWYUQDKh+ZGu/N2eqGeK/1+hQ8dkeQ/CZrWXvTesl aboAAwrDyusN60YaGzyZKz/+brQCfVCgPsiQXP+fHnCBWVbaks3rEYf7uF8HYLI1G2dr uDHipzDgckwHqei7073084x16tCnPYbr9gxDz5Zz1+Xbfx3JnSpZOQfi1tRqvuPGRRGy WL1oVFLd0vYMtvmkWJux0FP4H/AxXSpewA4bkMqvhetrpdE1qQ9LscQjsWsVbEqXM/j+ K7XA== X-Forwarded-Encrypted: i=1; AJvYcCV2PXxeYfNYt5yg7N0DSugXpDDxtR7QvV8dwUufxKq+cgB3iWyP82ug1k2daROB/veWyzD2gl7n15hlO9zB@lists.postgresql.org X-Gm-Message-State: AOJu0YwbnbOqgfsszsfkeb35V+bkKSx2yUEIlSYImM5cEGZUP0FJDJZV A0sAb/gBLBk16VWTE9T8w9vZkQ07CvnQfcIcgm3O2GVEjIXleLwkwlxJSM6pOcy1NThJpH+3KX1 ziMAFqS4M76bJ5oeMJecA1WqgzR+cAFldAnchHmgZ X-Gm-Gg: AZuq6aI+S8Gzy4LyHxRudjRRSDJlF/Pak3sYnEE0ZA6nSIJwFowxP9It+v+lCk8up85 43z8TYaf9qxGukLdrb0lav33joj43HLzqJShFvXnX76m2Gj7sxowBdRYRLaeGkYLW8M/ejDiBCe TEVckfb23HMDqyXzii6nQ4roKiat0qPjS/5JtqrSdvsBYnkd/8T/it1Rb7lGtV6YYt+kdIZ2BV1 Pc+Y0wGcFt5kgaZEeZ08Hl7UWMOfVmxfAx4EKu7UtA4tRCHD8wPu7CVIQzFSfC49BY+ozI4GA== X-Received: by 2002:a05:620a:1a20:b0:8c5:38d1:7734 with SMTP id af79cd13be357-8caefeb517emr124550685a.54.1770337141712; Thu, 05 Feb 2026 16:19:01 -0800 (PST) MIME-Version: 1.0 References: <20260204213032.15bab46b@ardentperf.com> <20260205150452.00006167@ardentperf.com> <1667818.1770336112@sss.pgh.pa.us> In-Reply-To: <1667818.1770336112@sss.pgh.pa.us> From: Jacob Champion Date: Thu, 5 Feb 2026 16:18:50 -0800 X-Gm-Features: AZwV_QgFzjXMjU4h9dQqhm_ijL2TvHYCRzS88uJp8F7jqIoDtG_UIZr1nfc4xqg Message-ID: Subject: Re: client_connection_check_interval default value To: Tom Lane Cc: Fujii Masao , Jeremy Schneider , "pgsql-hackers@lists.postgresql.org" , Marat Buharov , Greg Sabino Mullane , Thomas Munro 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 Thu, Feb 5, 2026 at 4:01=E2=80=AFPM Tom Lane wrote: > I think enabling it by default is a nonstarter, because it changes > behavior in a significant way. Specifically, it's always been the > case that if the client disconnects during a non-SELECT query (or > anything that doesn't produce output), the backend would complete that > query before ending the session. Ha, I hadn't even thought about the possibility of fire-and-forget... > I think it's very likely that there > are users depending on that behavior. From a quick search, yeah, probably: https://dba.stackexchange.com/questions/247206/will-query-continue-to-r= un-even-after-network-times-out --Jacob