Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group