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 1w9lN7-001iwX-06 for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Apr 2026 14:56:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w9lN5-009WQh-1b for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Apr 2026 14:56:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w9lMK-009Rmh-27 for pgsql-hackers@lists.postgresql.org; Mon, 06 Apr 2026 14:55:25 +0000 Received: from mail-ot1-x32c.google.com ([2607:f8b0:4864:20::32c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w9lMI-00000000um0-3VK6 for pgsql-hackers@lists.postgresql.org; Mon, 06 Apr 2026 14:55:24 +0000 Received: by mail-ot1-x32c.google.com with SMTP id 46e09a7af769-7d556c1a79eso5184737a34.3 for ; Mon, 06 Apr 2026 07:55:23 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775487322; cv=none; d=google.com; s=arc-20240605; b=C4yfSeRh1YyNUER1dMttB0+kgwBRTfids2Z+oiK3Uhkryi8Tsw+RVzwk2tnfBb7QtH QSRyqAt78vybcJTjoGS6BmlvLGpFBvibGCt/djtko1v0oGj+1DDVd1CBBVrR13ok+zLX OBdiUcZM1cSftOXJeWWIZDXDWPn17ncabwWgdoThEtlAb0sb1aiOsEgDGJmNmU1j1+0C QSD5Iy4vPUC8L9SXn5k1QNfLUQ5ee+kWLCbm44ILVyddDDWg6YV4TdGo+R/TqfVLPZj6 Qie74khsLJtR6iVCEsP0fkg9Ed52Sx/RDpjF9Va0vkhgtcj8R4Qlr0dNkoaJhxvb7UsU Bbxw== 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=0MxaYZc62CGcrI9Pz5/067tHkcBVbYsc9i47sdGA1DE=; fh=Yj/7PeQ6hY2i5coHKpUSaWjkWjX80QrrsbhkhWwq4gg=; b=PHTMcGVKPkqnNa2/zJlnJytAvIgb1aajjTsNVzbPL69E+n/YE+vdc0r0U5dgFQ/IsM t5nl549vvsWD+cALhpg3duD2AxHa2un2YhAZs5ZeEoD3PaPNauRjIOng4nLj4bVvPLec YXWB9xCouFz8nMhJD7u7ziRipOpvJEjRDs4g3qV0X5MqaXAohBl/uaWRo+TKsHEUzL4+ aDCrV3bmGLSK/Emf+KA9exOOR+kT7SuRw1Ec5Vd16fCkEjZTzZ4rAGI0VRtR/qQcdnRc fPsIUzkRhQu74+g28EjyQMIICzZgPtsiCyadofN1z5pR47HM3pwMQWh2GrgQ4jcWcxRx 72Qg==; 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=20251104; t=1775487322; x=1776092122; 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=0MxaYZc62CGcrI9Pz5/067tHkcBVbYsc9i47sdGA1DE=; b=MBJhG03sPnOiE1yMekq97g0FBUkOszccXYmNwRDPEDyUj7nj/zkb4Q4EMAzCFO6rmH nQmdcjX+jYCn7IBMYJS4XBhPgtcO/6yhmD+TsXYtyUpdOiAY8Yoil3whlw+iYcoxwGGt 9HnEWd8EE/6tdiqjTIZr8DDNvjurxeLHnybD972hPaUk6tAKCks3W+qyDxh6aGwbGsgU thD166p2DM79Lj4blV7jv4ZqRz2QjsA6r+ESFpZQgS9xxuB2Xh9roOOjhkN0MwFVBxb1 bnrzIjfLZOApuahgPq1mWx/y28ki+H4FrJymGhXMpie3ECFkoA7DSpQ2CnK1prEbrlbx NuLw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775487322; x=1776092122; 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=0MxaYZc62CGcrI9Pz5/067tHkcBVbYsc9i47sdGA1DE=; b=kgIv2ZkQti5/OyDQBdisnFnFr5scO6lrwO2s7q13bVCumLokF4NIgiJYHLoKCbGdvZ cd0Rt72iP5/IZZw4W7biB9DQD/rx1oUgCcbLor+LGWCyCO8YRf4j5cE4FLmOqg5VFuCI QLrhelYuW3OZH0MwpkkZ70MXwsgZ2DoWRBGGD6p9Nf1nHL3wupo6JtisvvB7taDVLMsk BbuDAbOsM/9AIi3f4Lmx5CMzmFSKxT/s5mM7P90F7SwAR+v5fusi8XuaVMOqF5jZX1iQ 0t3OWbxccxJCdR/XNRClru+qL43yrpzyB/EsELzh7SHhkElH3CUyZpDRvrLNYdN4syk/ pUuA== X-Forwarded-Encrypted: i=1; AJvYcCW2xBTubHPn9TwcMEme8Lii+BX+xryYnUJ7HS7Nwx/NjCgH9v/yPGFGmsUPYryZdqGXt858IEvzEkS2D7I8@lists.postgresql.org X-Gm-Message-State: AOJu0YzNdOtQVMfeCvffN0vaVWKo3vGYNhwPsLw/AwVn6WJfTdKcDm9D 5NjettZHaaJaufLtVT3HJWQw2pOjbTuDCaV/S9G7W3I8Ix9LTNyZAgfo48Ga0JsaL+nNYSTljUF sftENzbfDfaFx0odzGejVSuHHBEkXKJA= X-Gm-Gg: AeBDiesf3EkwYEbDcgZ0m45pgA3+9D2OKzHJWLC/B+Mv2GU5H6+pPBSSfLpVGDfVAWI hmjKCQ01PjyxQZx6w4kWSZz+wgNcHKgO6mTzqvQrZxhSaflguKkAsrTiJrP832MekYbGqdUElsY Hc03eM0rcWN7w9KwxXWVhQjeS28JsfpUtaK8IHs9Hj4tCTp8h0DdCPL6INpo2lIdTjw6Ho1XpRX 6QaJZ4eiYzZaVqPDr5cyedDj8sD5Oq8xwWYhEWBOG8NQBPFul1kiTd2pIIvfLQ8cDpvJZVuyP+z m60mCGuM+b4e9VxSzI90iAVwC48Kl0RUu3ON0bcNhQ== X-Received: by 2002:a05:6820:4b17:b0:681:aa84:9bb5 with SMTP id 006d021491bc7-6821df6b25fmr7269191eaf.20.1775487321737; Mon, 06 Apr 2026 07:55:21 -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, 6 Apr 2026 23:55:08 +0900 X-Gm-Features: AQROBzBxdPBaU6ee1W-M_GjSS-yoh5dhgfp41VYgeLCBfZteDXo2IPMMRB4hAAg 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, Apr 6, 2026 at 10:00=E2=80=AFPM H=C3=BCseyin Demir wrote: > Appreciated for the patch. I reviewed it quickly. > > In the test description it says that `still waiting logged exactly once d= espite pg_reload_conf() wakeups")` but the test sends via pg_log_backend_me= mory_contexts(). It would make sense to update it. > > ``` > - 1, "still waiting logged exactly once despite pg_reload_conf() wakeu= ps"); > + 1, "still waiting logged exactly once despite wakeups from pg_log_ba= ckend_memory_contexts()"); > ``` > > Secondly, before finishing the test it tries to check that no log_lock_wa= its messages are emitted. But the comment has the opposite meaning. > > ``` > - 'check that log_lock_waits message is emitted when the lock is acquir= ed after waiting' > + 'check that no log_lock_waits message is emitted when the lock is acq= uired after waiting' > ``` > > I'm not sure they need to change but these are the only topics I wanted t= o add. Otherwise, lgtm and thanks. > > I attached the v3 to convey my ideas. You can use it or update the existi= ng if you think the suggestions are reasonable. Thanks for the review and for updating the patch! Your changes look good to me. I also added a comment explaining why the test wakes the backend, and then pushed the patch. Thanks again! Regards, --=20 Fujii Masao