Re: Using multiple cores for index creation? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Using multiple cores for index creation?
Date
Msg-id 15052.1233278716@sss.pgh.pa.us
Whole thread Raw
In response to Re: Using multiple cores for index creation?  ("Joshua D. Drake" <jd@commandprompt.com>)
List 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 by date:

Previous
From: henk de wit
Date:
Subject: Re: Using multiple cores for index creation?
Next
From: Scott Marlowe
Date:
Subject: Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting)