From 7781f4e3e711ace6bcf9b6253a104b180cb78fcf Mon Sep 17 00:00:00 2001 From: Andrew Dunstan Date: Sun, 31 Jul 2022 16:41:50 -0400 Subject: Add --schema and --exclude-schema options to vacuumdb. These two new options can be used to either process all tables in specific schemas or to skip processing all tables in specific schemas. This change also refactors the handling of invalid combinations of command-line options to a new helper function. Author: Gilles Darold Reviewed-by: Justin Pryzby, Nathan Bossart and Michael Paquier. Discussion: https://postgr.es/m/929fbf3c-24b8-d454-811f-1d5898ab3e91%40migops.com --- doc/src/sgml/ref/vacuumdb.sgml | 66 ++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 66 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml index 956c0f01cbc..841aced3bd5 100644 --- a/doc/src/sgml/ref/vacuumdb.sgml +++ b/doc/src/sgml/ref/vacuumdb.sgml @@ -39,6 +39,40 @@ PostgreSQL documentation dbname + + vacuumdb + connection-option + option + + + + + + + + + + + schema + + + + + + + + + + schema + + + + + + + dbname + + vacuumdb connection-option @@ -244,6 +278,30 @@ PostgreSQL documentation + + + + + + Clean or analyze all tables in + schema only. Multiple + schemas can be vacuumed by writing multiple switches. + + + + + + + + + + Do not clean or analyze any tables in + schema. Multiple schemas + can be excluded by writing multiple switches. + + + + @@ -619,6 +677,14 @@ PostgreSQL documentation $ vacuumdb --analyze --verbose --table='foo(bar)' xyzzy + + To clean all tables in the foo and bar schemas + in a database named xyzzy: + +$ vacuumdb --schema='foo' --schema='bar' xyzzy + + + -- cgit v1.2.3