vacuumdb --analyze-only does not need to issue VACUUM (ONLY_DATABASE_STATS) ?

Fujii Masao <masao.fujii@gmail.com>

From: Fujii Masao <masao.fujii@gmail.com>

To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-08-08T06:57:36Z

Lists: pgsql-hackers

Attachments

v1-0001-vacuumdb-Skip-VACUUM-ONLY_DATABASE_STATS-with-ana.patch (application/octet-stream) patch v1-0001

Hi,

I noticed that vacuumdb --analyze-only currently issues
VACUUM (ONLY_DATABASE_STATS). Is this actually needed?
BTW, vacuumdb does not run this command when --analyze-in-stages
is specified.

The attached patch modifies vacuumdb to skip
VACUUM (ONLY_DATABASE_STATS) when --analyze-only is used

Regards,

-- 
Fujii Masao

Commits

vacuumdb: Do not run VACUUM (ONLY_DATABASE_STATS) when --analyze-only.
- 879c492480d0 19 (unreleased) landed