Re: client_connection_check_interval default value
Fujii Masao <masao.fujii@gmail.com>
From: Fujii Masao <masao.fujii@gmail.com>
To: Hüseyin Demir <huseyin.d3r@gmail.com>
Cc: Chao Li <li.evan.chao@gmail.com>, pgsql-hackers@lists.postgresql.org
Date: 2026-04-06T14:55:08Z
Lists: pgsql-hackers
On Mon, Apr 6, 2026 at 10:00 PM Hüseyin Demir <huseyin.d3r@gmail.com> wrote: > Appreciated for the patch. I reviewed it quickly. > > In the test description it says that `still waiting logged exactly once despite pg_reload_conf() wakeups")` but the test sends via pg_log_backend_memory_contexts(). It would make sense to update it. > > ``` > - 1, "still waiting logged exactly once despite pg_reload_conf() wakeups"); > + 1, "still waiting logged exactly once despite wakeups from pg_log_backend_memory_contexts()"); > ``` > > Secondly, before finishing the test it tries to check that no log_lock_waits messages are emitted. But the comment has the opposite meaning. > > ``` > - 'check that log_lock_waits message is emitted when the lock is acquired after waiting' > + 'check that no log_lock_waits message is emitted when the lock is acquired after waiting' > ``` > > I'm not sure they need to change but these are the only topics I wanted to add. Otherwise, lgtm and thanks. > > I attached the v3 to convey my ideas. You can use it or update the existing 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, -- Fujii Masao
Commits
-
Add TAP tests for log_lock_waits
- ca2b5443e2dc 19 (unreleased) landed
-
Add tests for lock statistics, take two
- 557a9f1e3e62 19 (unreleased) cited
-
Ensure "still waiting on lock" message is logged only once per wait.
- fd6ecbfa75ff 19 (unreleased) landed