vacuumdb: Teach vacuum_one_database() to reuse query results.
Nathan Bossart <nathan@postgresql.org>
vacuumdb: Teach vacuum_one_database() to reuse query results. Presently, each call to vacuum_one_database() queries the catalogs to retrieve the list of tables to process. A follow-up commit will add a "missing stats only" feature to --analyze-in-stages, which requires saving the catalog query results (since tables without statistics will have them after the first stage). This commit adds a new parameter to vacuum_one_database() that specifies either a previously-retrieved list or a place to return the catalog query results. Note that nothing uses this new parameter yet. Author: Corey Huinker <corey.huinker@gmail.com> Co-authored-by: Nathan Bossart <nathandbossart@gmail.com> Reviewed-by: John Naylor <johncnaylorls@gmail.com> Discussion: https://postgr.es/m/Z5O1bpcwDrMgyrYy%40nathan
Files
| Path | Change | +/− |
|---|---|---|
| src/bin/scripts/vacuumdb.c | modified | +194 −136 |
Discussion
- vacuumdb changes for stats import/export 36 messages · 2025-01-24 → 2025-07-30