Re: reindex creates predicate lock on index root

From: Dan Ports <drkp(at)csail(dot)mit(dot)edu>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: reindex creates predicate lock on index root
Date: 2011-06-08 03:02:26
Message-ID: 20110608030226.GE26076@csail.mit.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2011-06-08 03:37:22 Re: reindex creates predicate lock on index root
Previous Message Fujii Masao 2011-06-08 02:18:05 Re: WALInsertLock tuning