Using multiple cores for index creation?

Поиск
Список
Период
Сортировка
От henk de wit
Тема Using multiple cores for index creation?
Дата
Msg-id COL104-W37259F48A4C29A6F6068FF5C90@phx.gbl
обсуждение исходный текст
Ответы Re: Using multiple cores for index creation?
Re: Using multiple cores for index creation?
Список pgsql-performance
Hi,

When I try to restore a database dump on PostgreSQL 8.3 that's approximately 130GB in size and takes about 1 hour, I noticed index creation makes up the bulk of that time. I'm using a very fast I/O subsystem (16 Mtron Pro 7535 SSDs using a dual 1.2Ghz IOP/4GB cache RAID controller), fast CPUs (2 quad core C2Q's at 2.6Ghz) and 32GB RAM. From monitoring the restore process, I learned that only 10 minutes is spend doing IO, while the rest of the time is spend on creating the indexes. Index creation seems to be completely CPU bound.

The problem is that only 1 CPU core is used. My other 7 cores are just sitting there doing nothing. It seems to me that creating each index, especially for different tables, is something that can be done independently.

Is there some way I can let PostgreSQL use multiple cores for creating the indexes?

Thanks in advance


Express yourself instantly with MSN Messenger! MSN Messenger

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Max on union
Следующее
От: "Subbiah Stalin-XCGF84"
Дата:
Сообщение: Sort performance