Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 9C02363F12A for ; Wed, 23 Jun 2010 12:23:48 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 25340-01-5 for ; Wed, 23 Jun 2010 15:23:41 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web23606.mail.ird.yahoo.com (web23606.mail.ird.yahoo.com [87.248.115.49]) by mail.postgresql.org (Postfix) with SMTP id CBC64636A08 for ; Wed, 23 Jun 2010 12:23:40 -0300 (ADT) Received: (qmail 78746 invoked by uid 60001); 23 Jun 2010 15:23:39 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.uk; s=s1024; t=1277306619; bh=vTrqVpQP5hocCQDjmXbHDiN6wM0P6jiNomqsMA4UknE=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=r03p90WsLjvNCtpKWMF4x8H3TO4Q8qVnle3u0mrSE82ox/X4WB/HPT1cuD1juXFeiFiOqbIHusbcUUZO1LxNBUBvqdlC5GIjxjBicDdrPk2RzANQKHlr/ucr4BLArAs5Zx4IcK/HAgLuDKA9VtavG16jrD+9xKQNAwtsHqVb1FQ= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=5wBmCuB7Et3DBvk5bllFk+ryL/XBVdD8VRBL52kVQRkv8PcEXm/zArxdXQVirD1bJxT6FieKFcbVRXF0GP3LH4Yhs8TkeuaPPV+R6F1mgsKiExlhzfnqRZ6nDIFZ9DErL0OwU1GEfsFFFolCgNFkjk45/H+t01VZYxVMfql2M60=; Message-ID: <83864.78725.qm@web23606.mail.ird.yahoo.com> X-YMail-OSG: 9lHMU2sVM1kkPYhRp5GgzpcrLHl1MG5iDGdxWAGnBWjCFf1 50vGErrNJLDOJnBgC7K8HbJoWraHyGrZvIdHmQt1yyLVGI2RIzQfe_YHIHOG 0rlNaxIfAwbUuSMbTJnd0KGDFucJGJzoSBD2Ko8.Oszwuk08fgWvTbYYL99H 1p7hAFl06JNk0d75H84gHRPQyv7DxFSoM8SQPcaEt6z9HWBq0geT0gGzut35 L.vpbaxzThGW2yXqySVCcif3QiBQl7t5Yv5snqh1HH_kuLFIek35e_67h6r8 rXz7GLuQ5tHJTM4Pw3GYsnSk- Received: from [83.100.146.195] by web23606.mail.ird.yahoo.com via HTTP; Wed, 23 Jun 2010 15:23:39 GMT X-Mailer: YahooMailClassic/11.1.4 YahooMailWebService/0.8.104.274457 Date: Wed, 23 Jun 2010 15:23:39 +0000 (GMT) From: Glyn Astill Subject: Re: parallel option in pg_restore To: Tom Lane Cc: Igor Neyman , John Rouillard , Kevin Grittner , pgsql-admin@postgresql.org In-Reply-To: <22370.1277304011@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201006/189 X-Sequence-Number: 34967 --- On Wed, 23/6/10, Tom Lane wrote:=0A> Glyn Astill =0A> writes:=0A> > Good point.=A0 No I've not seen it= on a file=0A> smaller than 2GB, but the test I did was pretty basic - I=0A= > just trimmed down the size of all of my tables to create a=0A> dump that = was only 50Mb or so.=A0 It looks like Igor has=0A> a reproduceable case now= though, so hopefully Tom can figure=0A> out what's going off.=0A> =0A> I n= eglected to follow up to this -admin thread, but see=0A> http://archives.po= stgresql.org/pgsql-hackers/2010-06/msg01227.php=0A=0AThanks Tom, that's suf= ficient information to solve our problems here.=0A=0A=0A=0A