vacuumdb: Teach vacuum_one_database() to reuse query results.
authorNathan Bossart <nathan@postgresql.org>
Tue, 18 Mar 2025 21:32:55 +0000 (16:32 -0500)
committerNathan Bossart <nathan@postgresql.org>
Tue, 18 Mar 2025 21:32:55 +0000 (16:32 -0500)
commit9c03c8d187210f112371aab881b379bd4800562c
treec9501e41de3ceb3fe5e877baced1dba4d70668bf
parenta6524105d20b190fb4f5b2116e044e29be88f215
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
src/bin/scripts/vacuumdb.c