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