reindex creates predicate lock on index root

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема reindex creates predicate lock on index root
Дата
Msg-id 4DEE7FE7020000250003E2C1@gw.wicourts.gov
обсуждение исходный текст
Ответы Re: reindex creates predicate lock on index root  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: reindex creates predicate lock on index root  (Dan Ports <drkp@csail.mit.edu>)
Re: reindex creates predicate lock on index root  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
During testing of the SSI DDL changes I noticed that a REINDEX INDEX
created a predicate lock on page 0 of the index.  This is pretty
harmless, but mildly annoying.  There are a few other places where
it would be good to suppress predicate locks; these are listed on
the R&D section of the Wiki.  I hope to clean some of these up in
9.2. Unless a very clean and safe fix for the subject issue pops out
on further review, I'll add this to that list.
-Kevin


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

Предыдущее
От: "Mike Pultz"
Дата:
Сообщение: Re: smallserial / serial2
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Domains versus polymorphic functions, redux