Multiple index builds on same table - in one sweep?

Поиск
Список
Период
Сортировка
От Chris Ruprecht
Тема Multiple index builds on same table - in one sweep?
Дата
Msg-id DD8709CB-474F-4002-B555-1ED974371364@ruprecht.org
обсуждение исходный текст
Ответы Re: Multiple index builds on same table - in one sweep?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Multiple index builds on same table - in one sweep?  (Shaun Thomas <sthomas@peak6.com>)
Список pgsql-performance
I have a table that I need to rebuild indexes on from time to time (records get loaded before indexes get build).

To build the indexes, I use 'create index ...', which reads the entire table and builds the index, one at a time.
I'm wondering if there is a way to build these indexes in parallel while reading the table only once for all indexes
andbuilding them all at the same time. Is there an index build tool that I missed somehow, that can do this? 

Thanks,
Chris.



best regards,
chris
--
chris ruprecht
database grunt and bit pusher extraordinaíre


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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: Why it is using/not using index scan?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Multiple index builds on same table - in one sweep?