Re: Unexpected behavior when setting "idle_replication_slot_timeout"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>, Gunnar Morling <gunnar(dot)morling(at)googlemail(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Unexpected behavior when setting "idle_replication_slot_timeout"
Date: 2025-07-05 16:13:08
Message-ID: 474268.1751731988@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I wrote:
> I'm kind of down on changing the unit, because it will *silently*
> break configuration files where the value was set without a unit.

Oh, wait a second. I just noticed that this variable is new in v18.
So there won't be a compatibility issue as long as we change it in
v18 too. So changing it to a base of seconds seems sufficient,
and more in line with existing practice:

regression=# select name,unit from pg_settings where name like '%timeout';
name | unit
-------------------------------------+------
archive_timeout | s
authentication_timeout | s
checkpoint_timeout | s
deadlock_timeout | ms
idle_in_transaction_session_timeout | ms
idle_replication_slot_timeout | min
idle_session_timeout | ms
lock_timeout | ms
statement_timeout | ms
tcp_user_timeout | ms
transaction_timeout | ms
wal_receiver_timeout | ms
wal_sender_timeout | ms
(13 rows)

Using 'ms' seems clearly overkill, but there's precedent for
timeouts measured in seconds.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ben Caspi 2025-07-06 11:06:05 PostgreSQL Windows Installer defaults to "English_United States.1252" when choosing locale starting with "English"
Previous Message Tom Lane 2025-07-05 15:56:48 Re: Unexpected behavior when setting "idle_replication_slot_timeout"