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 1w249m-000qhp-23 for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Mar 2026 09:22:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w249l-008rBc-2D for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Mar 2026 09:22:38 +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 1w249l-008rBT-1G for pgsql-hackers@lists.postgresql.org; Mon, 16 Mar 2026 09:22:38 +0000 Received: from mail-oo1-xc35.google.com ([2607:f8b0:4864:20::c35]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w249k-00000000NK2-0eZD for pgsql-hackers@lists.postgresql.org; Mon, 16 Mar 2026 09:22:37 +0000 Received: by mail-oo1-xc35.google.com with SMTP id 006d021491bc7-66f747175d8so2271726eaf.0 for ; Mon, 16 Mar 2026 02:22:36 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773652956; cv=none; d=google.com; s=arc-20240605; b=U575ne81LAvjMwunX+T/Y98EAA7sW4Zqbbmwc8gLjz10s9kKxRAf/CuxmDuyrUYxVY +0jOnq5xYRct0jpxPGtbny82mP+MGzj71p0ijS6m8ouYf5LVuKEE09ZBPwNVGcd2HDvr 49NlHLeYCUNBsz8GzwdUWx+5mK8GjGW0MbBXgeJRamzOr695VOy/SiGvuB1VTQiyo/qz WRSs9AkEbdS7a/a/0W8FjHBwwZNk92Swkbtm0TTyDCczyHF3vlvSWEIq3m4SkvRZEnX9 khc8MNo9AjTCz7EzSvHduPwDiQ3sX/E7FmhxyVQZf5lIeh7eJJXoYpqOiZ4E5GMDTOG4 jLXg== 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=8X6zKkiXxuRJjIFVdIgiJBN6qt7bYkf6jtsD/ewwmCA=; fh=HXugIqWbt50L436nZ8s8skQfSxvwNNBaIWYYYW/85f4=; b=WyPwm857mtzvj4FuNmRjYpLutq5UJVMxIsoWQBePH8JIuASW6CgRB6DGa/UP5w7ebo q9rMZbMW8GfguSaOuGkgQNlZ6t0YPVNiRmbRWqh+x670bhAPof+FqjDeckUDnszT0CvJ h5P8PvBI4s/VJwyhO6eeA7y0RT1d3nkezgolWTMpgsXP6m4JGbTYjGcflS1WcwzOqBP8 2sTV9YFnW0T6X8SnvgEkQ5lH3zMz4AienkJxwmxfuNwdFBoh+N2+Kvcy5u+/bh4FqfA2 s1pp6kECL3zB0oFyAxfmhB8wB6cxs7aP1h4mWNlz5rPm4/cbNmeCwX6UrGoXQ1GrbP8H DSIg==; 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=gmail.com; s=20230601; t=1773652956; x=1774257756; 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=8X6zKkiXxuRJjIFVdIgiJBN6qt7bYkf6jtsD/ewwmCA=; b=Wk+5cdaAaG00Uw4cFVwomCo1JoDT39k3p0MV/03NH7stBk/Q0b05tKsaDFsGYLGYhw nWAzrcq31breFEOQsnrLKI+MlqHxEWPSE0zoDacHDgPdgMDTMGgYzSRnKHchd9iLJmq+ MJKWCMslQCaDz7BrnsoJdFcnBPq9ceE9dF/IV21cRPmzRX0PZdhVJwk7BxaYIikLmJ+D D02fx3O+84SZEmOXUNRz7Sd7/C2IueERcJBRQ6JXmDPDJ1vQkZ+3e+XSNkfH9pp1+n/5 QUacEXjkyts3v2JOsjuo7JX/L4kqi8eHN5IEmfcOKAbhcQrCwrSqVYVsR0q92QpeOFOj j6Fw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773652956; x=1774257756; 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=8X6zKkiXxuRJjIFVdIgiJBN6qt7bYkf6jtsD/ewwmCA=; b=Zlkpb9TclEfR0YK9Lmc0XyaDRCrVgt+8k7RIiPkxmVsmgGX1N9ArWGrx8Y4FtBPNIO ywqzBYGmLVdw8uvkWgEcnvy1vj70nTYh7Sf0RdQsijPdhUkdrfwlgMWtUxyL0zGQyr53 q+zssjPnkMbTWo/CQdBjIo4IqDwpxlpcsJnnrNupnp/oGsxnspxyM3FI9zqAUzlBv/aa eN9PnIe80BLVi2hRjU7YTlsVVe1PpPRItdcLi3Y+PEzd25D/15qfko/AWzS8YRE+ytBi x0+AAqVTFSwzye6fInzYB9aGHi/pnf+W33buAiLBpB5QGsbFKdQh+h15jv316UXdBoln 7yug== X-Forwarded-Encrypted: i=1; AJvYcCUWBH5MwVHNTE76B0+nz+ozghUB5p64FoULxn4yRtIkuoioJ31cEhG8oDlskPWHeRoMVAMvG7299n0S7iJV@lists.postgresql.org X-Gm-Message-State: AOJu0YwP+coULgGsnPciPkPFm2JxQqrmd+lN2e+HZ6LI+t5HumU3nojK /iokvNCK5VYYv0baMlGsfRldVm+dMN2dDza9q/ho5QfMcXQvY3dNSsuT6esQJKJsMcoQNO9J33F PxgXS6MxVq24RR9tG2wsbPwwII4EgLAk= X-Gm-Gg: ATEYQzzI3j9uk90Fblvaz6ajpo9T50AfJdUy08Ky9dfXRS0F6O5Qxyow9s9Qy2/p8kR Cjax0c5FJDYLFzLTYQkL3WP9ilAgleFzilbPQGnTDaOz1fxNBIdu0l8NSjqgwE0TGES9D2BoYAp FObqafFWqbZStVB0UuxqdCsfl0zwqtF6zjcVAEAvJqBc7F8Rb7ter24HzpDthwhb9AVXmiolt7s cf3v9BylUCjhi11GAjkbSeuCL6S0x7c6Kw+L9A3UCbracdHvM5Jaiz5cCCBkrwWyzoguS9jrtWb aD6CfIQVeIDrEl/J1QUXIh7iXEC2twBBtMKZ8kYrRw== X-Received: by 2002:a05:6820:188e:b0:67b:af39:9655 with SMTP id 006d021491bc7-67bda9b025cmr8708175eaf.19.1773652955958; Mon, 16 Mar 2026 02:22:35 -0700 (PDT) MIME-Version: 1.0 References: <20260204213032.15bab46b@ardentperf.com> <177304694613.1094603.10800724073727441272.pgcf@coridan.postgresql.org> <017AD77A-21B6-4B0A-8847-207914D53CE0@gmail.com> In-Reply-To: From: Fujii Masao Date: Mon, 16 Mar 2026 18:22:23 +0900 X-Gm-Features: AaiRm53whn7g0durY5M2CaVXNrOFulgFYoEhUKaFxp3T8iaEZkUuOA50Erd_2JI Message-ID: Subject: Re: client_connection_check_interval default value To: =?UTF-8?Q?H=C3=BCseyin_Demir?= Cc: Chao Li , pgsql-hackers@lists.postgresql.org 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 Mon, Mar 16, 2026 at 4:05=E2=80=AFPM H=C3=BCseyin Demir wrote: > The new v2 patch looks good to me. > > One open question from my side is should we include a test for this > behaviour ? Because we mentioned adding a different GUC in the future > to manage this rate-limiting approach. It can be useful in the future > once we consider/re-visit this approach. If the tests and other future > ideas can be developed later together we can consider adding tests > later. I agree it's worth adding such tests. From a quick look at the regression t= ests, there don't seem to be any tests for log_lock_waits itself. So before addin= g tests for the behavior introduced by the patch, we might first need to add some basic tests for log_lock_waits. Regards, --=20 Fujii Masao