Re: Using an SMP machine to make multiple indices on the same table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Using an SMP machine to make multiple indices on the same table
Дата
Msg-id 648.1003806566@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Using an SMP machine to make multiple indices on the same table  (Martin Weinberg <weinberg@osprey.astro.umass.edu>)
Ответы Re: Using an SMP machine to make multiple indices on the
Re: Using an SMP machine to make multiple indices on the
Список pgsql-general
Martin Weinberg <weinberg@osprey.astro.umass.edu> writes:
> On Postgresql 7.1.3, it seems that the table is locked after the
> first "create index" is started up.  Is this right?

AFAIK it's a share lock, which only prohibits modifications to the
table, not reads (nor concurrent index builds).  Not sure how you
expect the system to do better than that.

            regards, tom lane

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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Referential Integrity Violation not triggered
Следующее
От: Bruce Momjian
Дата:
Сообщение: LIMIT TODO item