CLUSTER, REINDEX, VACUUM in "read only" transaction?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема CLUSTER, REINDEX, VACUUM in "read only" transaction?
Дата
Msg-id 25968.1223646099@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: CLUSTER, REINDEX, VACUUM in "read only" transaction?  (Kenneth Marshall <ktm@rice.edu>)
Re: CLUSTER, REINDEX, VACUUM in "read only" transaction?  (Simon Riggs <simon@2ndQuadrant.com>)
Re: CLUSTER, REINDEX, VACUUM in "read only" transaction?  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Дерево обсуждения 
So I was looking for other omissions in utility.c, and I noticed that
check_xact_readonly() doesn't reject CLUSTER, REINDEX, or VACUUM.
Now the notion of "read only" that we're trying to enforce is pretty
weak (I think it's effectively "no writes to non-temp tables").
But I can't see that CLUSTER is a read-only operation even under the
weakest definitions, and I'm not seeing the rationale for REINDEX or
VACUUM here either.

Comments?
        regards, tom lane

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

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: How is random_page_cost=4 ok?
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: How is random_page_cost=4 ok?