Re: [GENERAL] Concurrency problem building indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Concurrency problem building indexes
Дата
Msg-id 7980.1145925761@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Concurrency problem building indexes  ("Jim C. Nasby" <jnasby@pervasive.com>)
Ответы Re: [GENERAL] Concurrency problem building indexes  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-hackers
"Jim C. Nasby" <jnasby@pervasive.com> writes:
> Was the code ever changed so that it won't update relpages if the number
> is the same?

Long ago.  I just tested it again, and AFAICS you can create indexes
concurrently so long as the underlying table isn't changing (ie,
neither reltuples nor relpages changes).
        regards, tom lane


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

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