On Wed, Oct 29, 2025 at 11:10:55AM +0800, wenhui qiu wrote:
> Typically, DBAs avoid setting autovacuum_freeze_max_age too close to
> vacuum_failsafe_age. Therefore, your logic most likely uses the
> vacuum_failsafe_age value.
> Would taking the average of the two be a better approach?
That approach would begin aggressively scaling the priority of tables
sooner, but I don't know if that's strictly better. In any case, I'd like
to avoid making the score calculation too magical.
--
nathan