Re: parallel pg_restore - WIP patch

Andrew Dunstan <andrew@dunslane.net>

From: Andrew Dunstan <andrew@dunslane.net>

To: Andrew Dunstan <andrew@dunslane.net>

Cc: Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>, Russell Smith <mr-russ@pws.com.au>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Jeffrey Baker <jwbaker@gmail.com>

Date: 2008-09-29T02:58:24Z

Lists: pgsql-hackers

Attachments

parallel_restore_3.patch (text/x-patch) patch


Andrew Dunstan wrote:
>
>
>>
>> this works better but there is something fishy still - using the same 
>> dump file I get a proper restore using pg_restore normally. If I 
>> however use -m for a parallel one I only get parts (in this case only 
>> 243 of the 709 tables) of the database restored ...
>>
>>
>>
>
> Yes, there are several funny things going on, including some stuff 
> with dependencies. I'll have a new patch tomorrow with luck. Thanks 
> for testing.
>
>

OK, in this version a whole heap of bugs are fixed, mainly those to do 
with dependencies and saved state. I get identical row counts in the 
source and destination now, quite reliably.

cheers

andrew