Re: parallel pg_restore - WIP patch - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: parallel pg_restore - WIP patch
Date
Msg-id 48DD4FD4.6090907@dunslane.net
Whole thread Raw
In response to Re: parallel pg_restore - WIP patch  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Responses Re: parallel pg_restore - WIP patch  (Joshua Drake <jd@commandprompt.com>)
Re: parallel pg_restore - WIP patch  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers

Stefan Kaltenbrunner wrote:
> Andrew Dunstan wrote:
>>
>>
>> This version of the patch should fix the "shared file descriptor" bug 
>> Russell Smith noticed. It also disables the 1/2 second sleep between 
>> forks, so the performance on a small db (regression) is vastly improved.
>
> 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.

cheers

andrew


pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: parallel pg_restore - WIP patch
Next
From: Joshua Drake
Date:
Subject: Re: parallel pg_restore - WIP patch