Avoid extra "skipping" messages from VACUUM/ANALYZE - Mailing list pgsql-hackers

From Jeff Davis
Subject Avoid extra "skipping" messages from VACUUM/ANALYZE
Date
Msg-id c0a85c2e83158560314b576b6241c8ed0aea1745.camel@j-davis.com
Whole thread Raw
Responses Re: Avoid extra "skipping" messages from VACUUM/ANALYZE  (Nathan Bossart <nathandbossart@gmail.com>)
List pgsql-hackers
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 first, and then check privileges second.

Found while reviewing the MAINTAIN privilege patch. Implemented with
his suggested fix. I intend to commit soon.


--
Jeff Davis
PostgreSQL Contributor Team - AWS



Attachment

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Add index scan progress to pg_stat_progress_vacuum
Next
From: "David G. Johnston"
Date:
Subject: Document aggregate functions better w.r.t. ORDER BY