Do we reduce autovacuum_naptime max values

From: wenhui qiu <qiuwenhuifx(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Do we reduce autovacuum_naptime max values
Date: 2026-09-09 09:49:51
Message-ID: CAGjGUAJSuWzskc=6Kkh+3BPU6AfRm62MWdTAc=7-jPKxxanUpA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

HI
I’ve heard through various channels that `autovacuum_naptime` was
mistakenly set to 23 hours, resulting in an XID wraparound incident. Maybe
the max value of more than 1 hour is too large ,so can we reduce the max
value to 3600? Of course, an inappropriate XID request is also a
contributing factor to the incident.We believe a reasonable range should be
set for this maximum value.

Thanks

Browse pgsql-hackers by date

  From Date Subject
Previous Message Zsolt Parragi 2026-09-09 09:47:06 Re: pg_stat_progress_cluster: do not default to CLUSTER