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

From Tom Lane
Subject Re: reindex creates predicate lock on index root
Date
Msg-id 10465.1307547651@sss.pgh.pa.us
Whole thread Raw
In response to Re: reindex creates predicate lock on index root  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List 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


pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: reducing the overhead of frequent table locks - now, with WIP patch
Next
From: Merlin Moncure
Date:
Subject: Re: Error in PQsetvalue