From: | Gunnar Morling <gunnar(dot)morling(at)googlemail(dot)com> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Unexpected behavior when setting "idle_replication_slot_timeout" |
Date: | 2025-07-04 09:54:15 |
Message-ID: | CADGJaX_0+FTguWpNSpgVWYQP_7MhoO0D8=cp4XozSQgaZ40Odw@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi all,
I am exploring the new setting "idle_replication_slot_timeout" in Postgres
18; for testing purposes, I set the value to "30s", which, unexpectedly to
me, didn't cause an idle slot to be invalidated when I triggered a
checkpoint after the timeout had been reached.
The docs of the option state that the value is rounded up or down to the
nearest full minute, so I reckon "30s" gets rounded down to 0, thus
effectively disabling the feature. It might be less surprising to users if
values between "1s" and "59s" get actually always rounded up to one minute?
Arguably, that'd seem the more intuitive behavior to me. Alternatively,
logging a warning might be considered for values between "1s" and "30s"?
Curious what folks here think.
Thanks and all the best,
--Gunnar
From | Date | Subject | |
---|---|---|---|
Next Message | Nisha Moond | 2025-07-04 12:14:04 | Re: Unexpected behavior when setting "idle_replication_slot_timeout" |
Previous Message | Tom Lane | 2025-07-03 17:48:14 | Re: BUG #18970: Atempt to alter type of table column used in row type with check leads to assertion failure |