Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id A508463316D for ; Tue, 14 Apr 2009 06:53:35 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 15719-07; Tue, 14 Apr 2009 06:53:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail137074.authsmtp.com (outmail137074.authsmtp.com [62.13.137.74]) by mail.postgresql.org (Postfix) with ESMTP id 275E1633037; Tue, 14 Apr 2009 06:47:45 -0300 (ADT) Received: from mail-c189.authsmtp.com (mail-c189.authsmtp.com [62.13.128.71]) by punt4.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n3E9lixh085349; Tue, 14 Apr 2009 10:47:44 +0100 (BST) Received: from [192.168.0.4] (85-211-223-92.dyn.gotadsl.co.uk [85.211.223.92]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n3E9lgwv067758; Tue, 14 Apr 2009 10:47:42 +0100 (BST) Subject: Re: pgsql: pg_restore -jN does not equate "multiple jobs", so partly revert From: Simon Riggs To: Alvaro Herrera , Andrew Dunstan Cc: pgsql-committers@postgresql.org In-Reply-To: <20090414000635.74B8D7540F4@cvs.postgresql.org> References: <20090414000635.74B8D7540F4@cvs.postgresql.org> Content-Type: text/plain Date: Tue, 14 Apr 2009 10:49:08 +0100 Message-Id: <1239702548.16396.97.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 4caba112-28d9-11de-bc7b-001f29070be2 X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadRtFaQFbbElD HGQLW11EUV17XWR/ bwgfZQBDYEtPQQdo U1ZAQE1QEQdtHhxP WB1rW0UlMENGfnl3 YE4sX3JdXAp+Jhcv E09VF3AEbTNpdWEe BBVFJVBTIh5Kfh4T aFl/U3NfNGdJBC9q VzwYGBUUHAljBR5u d0kVIkkLRRRDBjEL XR0ZATI1EAVARQN7 IxsrMRYaG1pZP1wv OEcsERgdLhsOCxVa EiMsAihTPBNFDzEs RRtTR1IaAXVHTDlR GAFA X-Authentic-SMTP: 61633235383639.kestrel.dmpriest.net.uk:1378/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200904/180 X-Sequence-Number: 36674 On Tue, 2009-04-14 at 00:06 +0000, Alvaro Herrera wrote: > Log Message: > ----------- > pg_restore -jN does not equate "multiple jobs", so partly revert the > previous patch. I notice that the release notes talk about "parallel restore", yet the word parallel is not used in the docs anywhere. The section on restoring a dump makes no mention of this new facility, nor does the perf tips section. Also says that the option doesn't work with --single-transaction, so we should say that you've added in TRUNCATE to make the COPY go faster (or haven't you? I know we discussed it). -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support