Re: Unexpected behavior when setting "idle_replication_slot_timeout"
David G. Johnston <david.g.johnston@gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Amit Kapila <amit.kapila16@gmail.com>,
Fujii Masao <masao.fujii@oss.nttdata.com>, Nisha Moond <nisha.moond412@gmail.com>,
Gunnar Morling <gunnar.morling@googlemail.com>, pgsql-bugs@lists.postgresql.org
Date: 2025-07-05T06:16:47Z
Lists: pgsql-bugs
On Fri, Jul 4, 2025 at 10:35 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote: > On the other hand, if the behavior is clearly documented, as I have > tried to do with my patch, it should be fine. So I'll rest my case if > you apply my patch. > > We should clearly document how rounding works in section 19.1.1 (which we mostly do; "If the parameter is of integer type, a final rounding to integer occurs after any unit conversion.") and not in every time-related setting that chooses to use something larger than microseconds. So, 30s is 'unit converted' up to 0.5 minutes (not explicitly explained...) then rounded to zero (which is odd, half normally rounds up...). I'm against cluttering up the individual settings docs with this detail. If the change from idle to inactive is needed in the description we should just admit we named it wrong in the first place. As-is, the description matches the name and the callout to the field in the second paragraph precisely clears up what this setting at least cares about. The reader should be directed to how that field is computed should they need clarification. Thus, I'd accept but not find required the idle/inactive wording change to any of various degrees; and would ask that any clarification regarding generic setting value interpretation be relegated to 19.1.1 where all such settings can benefit. David J.
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
doc: Clarify meaning of "idle" in idle_replication_slot_timeout.
- afb64a56d9c1 18.0 landed
- 110e6dcaa659 19 (unreleased) landed
-
Change unit of idle_replication_slot_timeout to seconds.
- 37c76aeb9ae3 18.0 landed
- 05dedf43d380 19 (unreleased) landed