Re: [GENERAL] Concurrency problem building indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Concurrency problem building indexes
Дата
Msg-id 28643.1147314314@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Concurrency problem building indexes  (Wes <wespvp@syntegra.com>)
Список pgsql-hackers
I forgot to mention it in the commit message, but this patch
http://archives.postgresql.org/pgsql-committers/2006-05/msg00069.php
includes a fix to avoid "tuple concurrently updated" failures in
CREATE INDEX's update of the parent relation's pg_class entry.
I'm still not convinced that that's where your problem is, however,
because AFAICS that ought to be a pretty low-probability scenario.
If that fixes it for you then there's something pushing the system
to complete index builds at about the same time, and I don't see
what that would be.
        regards, tom lane


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

Предыдущее
От: Zdenek Kotala
Дата:
Сообщение: [TODO] Allow commenting of variables ...
Следующее
От: "Jaime Casanova"
Дата:
Сообщение: Re: BEGIN inside transaction should be an error