Re: Do we reduce autovacuum_naptime max values - Mailing list pgsql-hackers

From wenhui qiu
Subject Re: Do we reduce autovacuum_naptime max values
Date
Msg-id CAGjGUAJbJtD+qM=BXD2gOJors33qpdsB1m2-FFOmA-kJZs3whQ@mail.gmail.com
Whole thread
Responses Re: Do we reduce autovacuum_naptime max values
List pgsql-hackers
HI Daniel
 
> The current range 1..INT_MAX/1000 is indeed pretty wide, but I think it's hard,
> or even impossible, to conclude that no one would ever want more than X.  Could
> the documentation be improved perhaps?

Actually, I believe that lowering this value to a reasonable range is the most fundamental solution. By reducing the maximum value of this parameter, an error message will appear if it is set incorrectly, which can prevent disasters caused by incorrect settings. Moreover, lowering this value to 3600 seconds is still an unreasonably high value—but it’s at least much better than setting it to 23 hours.Personally, I think anything over 10 minutes is unacceptable.

 
Thanks 

pgsql-hackers by date:

Previous
From: wenhui qiu
Date:
Subject: Re: PG 19 status blog report
Next
From: Alexander Lakhin
Date:
Subject: Re: Regression tests failures due to concurrent grants