Re: reindex creates predicate lock on index root

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Cc: "Heikki Linnakangas" <heikki.linnakangas@enterprisedb.com>, "Dan Ports" <drkp@csail.mit.edu>, "Robert Haas" <robertmhaas@gmail.com>, pgsql-hackers@postgresql.org
Date: 2011-06-08T15:40:51Z
Lists: pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote:
>> You can have one snapshot pushed to the active snapshot stack, and
>> do a DDL operation like reindex using a different snapshot. You'll
>> have to check the snapshot in the HeapScanDesc.
 
> Will look at that.  Do you think it makes more sense to pass in the
> snapshot on all these calls and test it within predicate.c, or
> condition the calls on this?

I'd vote for passing in the snapshot.  I can foresee wanting to know
exactly which snapshot is in question in this code, anyway.

			regards, tom lane