digoal
2022-08-08
PostgreSQL , vacuumdb , schema , 多租户
vacuumdb客户端增加指定schema和排除schema 选项, 方便以schema为多租户场景的vacuum管理.
Add --schema and --exclude-schema options to vacuumdb.
author Andrew Dunstan <andrew@dunslane.net>
Sun, 31 Jul 2022 20:41:50 +0000 (16:41 -0400)
committer Andrew Dunstan <andrew@dunslane.net>
Sun, 31 Jul 2022 20:46:13 +0000 (16:46 -0400)
commit 7781f4e3e711ace6bcf9b6253a104b180cb78fcf
tree 97e5f9b2a619aff23241df7aad229e8d3d1393bb tree
parent e1c95e50e99ae8ed9a779c505a289e24a2df195e commit | diff
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