Re: Documentation clarification re: ANALYZE

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Documentation clarification re: ANALYZE
Дата
Msg-id CAKFQuwY8f_6bFi1Hfq5vWU8jFVSOshDCnbjtdfi-V5nRsSK+=w@mail.gmail.com
обсуждение исходный текст
Ответ на Documentation clarification re: ANALYZE  (Isaac Morland <isaac.morland@gmail.com>)
Ответы Re: Documentation clarification re: ANALYZE  (Isaac Morland <isaac.morland@gmail.com>)
Re: Documentation clarification re: ANALYZE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Wed, Aug 7, 2019 at 2:14 PM Isaac Morland <isaac.morland@gmail.com> wrote:
I'm looking at https://www.postgresql.org/docs/current/sql-analyze.html, where it says “Without a table_and_columns list, ANALYZE processes every table and materialized view in the current database that the current user has permission to analyze.”.

I don’t believe there is a separate “analyze” permission, so which tables is this? Tables owned by the user? Ones where it can insert/update/delete? Ones where it can select?

Owners only - at least in previous releases.  I don't recall whether the addition of new roles to cover subsets of administrative privileges ever was extended to cover vacuum/analyze but I do not think it has.

David J.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: no default hash partition
Следующее
От: Isaac Morland
Дата:
Сообщение: Re: Documentation clarification re: ANALYZE