Re: reindex creates predicate lock on index root

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: reindex creates predicate lock on index root
Дата
Msg-id 4DEF50C9020000250003E2FF@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: reindex creates predicate lock on index root  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: reindex creates predicate lock on index root  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote:
>>  The attached patch has not yet been tested, but I'll test it
>> today along with the latest committed code.
> 
> You can't use GetActiveSnapshot() for this.
Yeah, it didn't take much testing to find that out.  I had a naive
assumption that the GetActiveSnapshot would return whatever snapshot
was in use at the point of the call.
> 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?
-Kevin


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: SSI heap_insert and page-level predicate locks
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: reducing the overhead of frequent table locks - now, with WIP patch