Re: reindex creates predicate lock on index root

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: reindex creates predicate lock on index root
Дата
Msg-id 10465.1307547651@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: reindex creates predicate lock on index root  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список 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 по дате отправления:

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: reducing the overhead of frequent table locks - now, with WIP patch
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Error in PQsetvalue