Re: [GENERAL] Concurrency problem building indexes

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: [GENERAL] Concurrency problem building indexes
Дата
Msg-id 20060425164804.GA27351@surnet.cl
обсуждение исходный текст
Ответ на Re: [GENERAL] Concurrency problem building indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [GENERAL] Concurrency problem building indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Catalog Access (was: [GENERAL] Concurrency problem building indexes)  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-hackers
I'm late to this thread, but maybe we can make the process of storing
the new data in pg_class take a lock using LockObject() or something
like that to serialize the access to the pg_class row.  The idea would
be that this lock doesn't conflict with a LockRelation(), but it would
of course conflict with itself so no two CREATE INDEXES can enter that
code section concurrently.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


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

Предыдущее
От: Ben Clewett
Дата:
Сообщение: Installation on Duel-Core Pentium XP
Следующее
От: Tom Lane
Дата:
Сообщение: Re: FOR UPDATE lock problem ?