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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kenneth Marshall <ktm(at)rice(dot)edu>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: CLUSTER, REINDEX, VACUUM in "read only" transaction?
Date: 2008-10-10 13:52:24
Message-ID: 26242.1223646744@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Kenneth Marshall <ktm(at)rice(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2008-10-10 14:05:11 Re: TODO item: adding VERBOSE option to CLUSTER [with patch]
Previous Message Kenneth Marshall 2008-10-10 13:50:45 Re: CLUSTER, REINDEX, VACUUM in "read only" transaction?