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

Kenneth Marshall <ktm@rice.edu> writes:
> On Fri, Oct 10, 2008 at 09:41:39AM -0400, Tom Lane wrote:
>> 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.

> CLUSTER, REINDEX, and VACUUM are read-only to me because they do not
> change what I will call the actual working data in the database. Also,
> how could you address problems with index imbalance or heap organization?

Why would you expect to be able to address such things in a read-only
transaction?
        regards, tom lane