Postgres Pro
Downloads
Home   >   mailing lists

Re: reindex creates predicate lock on index root - Mailing list pgsql-hackers

From Dan Ports
Subject Re: reindex creates predicate lock on index root
Date
Msg-id 20110608030226.GE26076@csail.mit.edu
Whole thread Raw
In response to reindex creates predicate lock on index root  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
Tree view 
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/

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: WALInsertLock tuning
Next
From: "Kevin Grittner"
Date:
Subject: Re: reindex creates predicate lock on index root