vacuumdb: add --dry-run

Corey Huinker <corey.huinker@gmail.com>

From: Corey Huinker <corey.huinker@gmail.com>

To: pgsql-hackers@postgresql.org

Cc: nathandbossart@gmail.com

Date: 2025-11-10T19:44:41Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add ParallelSlotSetIdle().
- 750816971b35 19 (unreleased) landed
vacuumdb: Add --dry-run.
- d107176d27c7 19 (unreleased) landed
vacuumdb: Move some variables to the vacuumingOptions struct.
- cf1450e57799 19 (unreleased) landed
Log a note at program start when running in dry-run mode
- c05dee191125 19 (unreleased) cited

Attachments

v1-0001-Add-dry-run-to-vacuumdb.patch (text/x-patch) patch v1-0001

This is a small patch to add a new option to vacuumdb to answer the
question "what commands will actually be run by this combination of
command-line switches against this database?" without actually running the
commands.

Including Nathan because we had previously discussed the utility of just
such a thing.