Re: Using multiple cores for index creation?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Using multiple cores for index creation?
Дата
Msg-id 15052.1233278716@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Using multiple cores for index creation?  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-performance
"Joshua D. Drake" <jd@commandprompt.com> writes:
> On Thu, 2009-01-29 at 18:09 -0500, Robert Haas wrote:
>> Andrew Dunstan has been working on this problem.  His latest parallel
>> restore patch can be found here:
>>
>> http://archives.postgresql.org/message-id/4977E070.6070604@dunslane.net

> Yeah but that isn't useful for 8.3.

Sure it is.  Andrew has made a point of making sure that the improved
version of pg_restore can work against older servers (not sure how far
back, but it's definitely supposed to work with 8.3).

> What can be done in this specific
> situation is to make sure you dump with the -Fc option...

You're essentially proposing a manual reimplementation of Andrew's
patch ...

            regards, tom lane

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

Предыдущее
От: henk de wit
Дата:
Сообщение: Re: Using multiple cores for index creation?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting)