Re: SIREAD lock versus ACCESS EXCLUSIVE lock

Kevin Grittner <kevin.grittner@wicourts.gov>

From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Simon Riggs" <simon@2ndQuadrant.com>, "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Cc: "Dan Ports" <drkp@csail.mit.edu>, "pgsql-hackers" <pgsql-hackers@postgresql.org>
Date: 2011-05-03T18:24:19Z
Lists: pgsql-hackers
Just a quick status update.
 
I wrote:
 
> Consider this a WIP patch
 
The serializable branch on my git repo has a modified form of this
which has been tested successfully with:
 
DROP INDEX
REINDEX
VACUUM FULL
CLUSTER
ALTER TABLE
 
I'm holding off on posting another version of the patch until I
cover the remaining commands, which are:
 
TRUNCATE TABLE
DROP TABLE
DROP DATABASE
 
I'm having to work on this off-hours at the moment, so expect the
patch to come sometime this weekend.
 
-Kevin