Horton

Re: SIREAD lock versus ACCESS EXCLUSIVE lock

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

View thread
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: simon@2ndquadrant.com, drkp@csail.mit.edu, pgsql-hackers@postgresql.org, tgl@sss.pgh.pa.us
Date: 2011-06-08T11:26:16Z
Lists: pgsql-hackers 
On 08.06.2011 14:18, Heikki Linnakangas wrote:
> I just looked back
> at your old email where you listed the different DDL operations, and
> notice that we missed VACUUM FULL as well
> (http://archives.postgresql.org/message-id/4DBD7E91020000250003D0D6@gw.wicourts.gov).
> I'll look into that.

Never mind that, VACUUM FULL uses cluster_rel(), so that's covered already.

> ALTER INDEX was also still an open question in that email.

None of the variants of ALTER INDEX do anything that affects predicate 
locks, so that's OK too.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com