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 по дате отправления: