Re: Avoid extra "skipping" messages from VACUUM/ANALYZE

2022-12-30 Thread Nathan Bossart
On Tue, Dec 13, 2022 at 07:40:59PM -0800, Nathan Bossart wrote: > Granted, this likely won't create as much noise as a database-wide VACUUM, > but perhaps we could add a relkind check in expand_vacuum_rel() and swap > the checks in vacuum_rel()/analyze_rel(), too. I don't know if it's worth > the

Re: Avoid extra "skipping" messages from VACUUM/ANALYZE

2022-12-13 Thread Nathan Bossart
On Tue, Dec 13, 2022 at 06:29:56PM -0800, Jeff Davis wrote: > Right now, if an unprivileged user issues VACUUM/ANALYZE (without > specifying a table), it will emit messages for each relation that it > skips, including indexes, views, and other objects that can't be a > direct target of VACUUM/ANALY

Avoid extra "skipping" messages from VACUUM/ANALYZE

2022-12-13 Thread Jeff Davis
Right now, if an unprivileged user issues VACUUM/ANALYZE (without specifying a table), it will emit messages for each relation that it skips, including indexes, views, and other objects that can't be a direct target of VACUUM/ANALYZE anyway. Attached patch causes it to check the type of object firs