Re: remove autoanalyze corner case
Shinya Kato <shinya11.kato@gmail.com>
From: Shinya Kato <shinya11.kato@gmail.com>
To: Nathan Bossart <nathandbossart@gmail.com>
Cc: Sami Imseih <samimseih@gmail.com>, Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>,
Robert Treat <rob@xzilla.net>, satyanarlapuram@gmail.com, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2026-04-05T13:46:08Z
Lists: pgsql-hackers
Attachments
- v2-0001-remove-autoanalyze-corner-case.patch (application/octet-stream) patch v2-0001
On Sat, Apr 4, 2026 at 11:55 AM Nathan Bossart <nathandbossart@gmail.com> wrote: > Well, autoanalyze only runs in this case if autovacuum is disabled via the > table's autovacuum_enabled reloption and _not_ disabled via the autovacuum > or track_counts GUCs. I think this is pretty clearly unintentional, as I > can find no mention in the code, archives, or docs. And unless I'm missing > something, it's completely unnecessary. So IMHO we should just remove it. +1. I think it might be better to mention this in the documentation to make the behavior explicit. What do you think about stating that an anti-wraparound autovacuum does not perform an ANALYZE, like in the attached patch? -- Best regards, Shinya Kato NTT OSS Center
Commits
-
Remove autoanalyze corner case.
- e3481edfd1b6 19 (unreleased) landed