Re: [GENERAL] Concurrency problem building indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Concurrency problem building indexes
Дата
Msg-id 9505.1145937776@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Concurrency problem building indexes  (Wes <wespvp@syntegra.com>)
Ответы Re: [GENERAL] Concurrency problem building indexes  (Wes <wespvp@syntegra.com>)
Список pgsql-hackers
Wes <wespvp@syntegra.com> writes:
> I can duplicate the error at will.

[ shrug... ]  Worksforme.

There is a short interval at the end of the first CREATE INDEX on the
table where the problem would happen if another CREATE INDEX tries to
modify the pg_class row before the first one's committed.  That would be
hard to hit with any regularity though.  Subsequent CREATE INDEXes after
that should be completely reliable.  If you are modifying the table
while it's being indexed, then the same small window would apply for
each CREATE INDEX not just the first ... but you didn't admit to that.

Care to put together a self-contained test case?
        regards, tom lane


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

Предыдущее
От: Wes
Дата:
Сообщение: Re: [GENERAL] Concurrency problem building indexes
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Google SoC--Idea Request