Re: Unexpected behavior when setting "idle_replication_slot_timeout" - Mailing list pgsql-bugs

From Fujii Masao
Subject Re: Unexpected behavior when setting "idle_replication_slot_timeout"
Date
Msg-id e0789f10-5b48-4d6b-a32c-0f4426d254df@oss.nttdata.com
Whole thread Raw
In response to Re: Unexpected behavior when setting "idle_replication_slot_timeout"  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Unexpected behavior when setting "idle_replication_slot_timeout"
Re: Unexpected behavior when setting "idle_replication_slot_timeout"
List pgsql-bugs

On 2025/07/05 1:07, Laurenz Albe wrote:
> On Sat, 2025-07-05 at 00:22 +0900, Fujii Masao wrote:
>> On 2025/07/04 23:12, Fujii Masao wrote:
>>> But I wonder why the current unit of this GUC is minutes (GUC_UNIT_MIN).
>>> Since at least two users (including myself) tried to set it to a value
>>> less than 1 minute, it might worth considering changing the unit to seconds
>>> (GUC_UNIT_S). Also which would reduces the chance of the reported trouble.
>>
>> Attached patch changes unit of idle_replication_slot_timeout to seconds.
> 
> -1
> 
> I think that the reason that several users tried to set it it less than a minute
> is that they were trying to test the feature and didn't want to wait long.
> I cannot imagine that anybody will want to abandon a standby server just
> because it is idle for more than 30 seconds.

Maybe. But changing the unit to seconds doesn't make things worse, does it?
It still allows users to set values greater than 1 minute, and also less than
1 minute for debugging or testing purposes, if needed.

Or are you suggesting we should disallow values below 1 minute?

Regards,

-- 
Fujii Masao
NTT DATA Japan Corporation




pgsql-bugs by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Unexpected behavior when setting "idle_replication_slot_timeout"
Next
From: Gunnar Morling
Date:
Subject: Re: Unexpected behavior when setting "idle_replication_slot_timeout"