ANALYZE being a read v write operation clarification

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема ANALYZE being a read v write operation clarification
Дата
Msg-id 175771747377.860.519892204627285536@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: ANALYZE being a read v write operation clarification
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/17/sql-analyze.html
Description:

In the ANALYZE docs it states,
- "ANALYZE collects statistics about the contents of tables in the database,
and stores the results in the pg_statistic system catalog"
- "ANALYZE requires only a read lock on the target table".

When trying to determien if this command could be run with
`default_transaction_read_only` set to `on,` I was left stumped on whether
this is a read only or read-write operation. It is unclear to me, what
"stores" in the context of the "pg_statistic system catalog" means, and
whether that requires a write operation. I'm potentially missing
understanding on the workings of the `pg_statistic` system catalog, but
figured this could be a small improvement made to clarify the docs about
this operation.

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