Avoid extra "skipping" messages from VACUUM/ANALYZE

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Avoid extra "skipping" messages from VACUUM/ANALYZE
Дата
Msg-id c0a85c2e83158560314b576b6241c8ed0aea1745.camel@j-davis.com
обсуждение исходный текст
Ответы Re: Avoid extra "skipping" messages from VACUUM/ANALYZE  (Nathan Bossart <nathandbossart@gmail.com>)
Список 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



Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: Add index scan progress to pg_stat_progress_vacuum
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Document aggregate functions better w.r.t. ORDER BY