Horton

Re: reindex creates predicate lock on index root

Dan Ports <drkp@csail.mit.edu>

View thread
From: Dan Ports <drkp@csail.mit.edu>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-hackers@postgresql.org
Date: 2011-06-08T03:02:26Z
Lists: pgsql-hackers 
On Tue, Jun 07, 2011 at 07:45:43PM -0500, Kevin Grittner wrote:
> During testing of the SSI DDL changes I noticed that a REINDEX INDEX
> created a predicate lock on page 0 of the index.

Really? That surprises me, and I couldn't reproduce it just now.

Dan

-- 
Dan R. K. Ports              MIT CSAIL                http://drkp.net/