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

Поиск
Список
Период
Сортировка
От Martin Weinberg
Тема Using an SMP machine to make multiple indices on the same table
Дата
Msg-id 200110222138.RAA15338@osprey.astro.umass.edu
обсуждение исходный текст
Ответы Re: Using an SMP machine to make multiple indices on the same table
Re: Using an SMP machine to make multiple indices on the same table
Список pgsql-general
Дерево обсуждения 
Folks,

We have some big tables (1.2 billion records) and indexing is quite
time consuming.  Since we have this running on dual Athlon box, it
would be great to make indices in parallel.

On Postgresql 7.1.3, it seems that the table is locked after the
first "create index" is started up.  Is this right?  Is there any
way to do this in parallel?

--Martin

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How to insert with a serial
Следующее
От: Keary Suska
Дата:
Сообщение: Re: Upgrade