Re: parallel pg_restore - WIP patch

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Russell Smith <mr-russ(at)pws(dot)com(dot)au>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Jeffrey Baker <jwbaker(at)gmail(dot)com>
Subject: Re: parallel pg_restore - WIP patch
Date: 2008-09-26 21:03:51
Message-ID: 48DD4E37.3090905@kaltenbrunner.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 ...

Stefan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2008-09-26 21:10:44 Re: parallel pg_restore - WIP patch
Previous Message Andrew Chernow 2008-09-26 19:39:08 Re: About the parameter of API: PQprepared