Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id B69A16501A9
	for <pgsql-patches-postgresql.org@postgresql.org>;
	Mon, 21 Jul 2008 16:20:31 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 28295-05 for
	<pgsql-patches-postgresql.org@postgresql.org>;
	Mon, 21 Jul 2008 16:20:24 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mk-outboundfilter-6-a-2.mail.uk.tiscali.com
	(mk-outboundfilter-6-a-2.mail.uk.tiscali.com [212.74.114.16])
	by postgresql.org (Postfix) with ESMTP id 7B9216501AD
	for <pgsql-patches@postgresql.org>;
	Mon, 21 Jul 2008 16:20:26 -0300 (ADT)
X-Trace: 
 4903510/mk-outboundfilter-6.mail.uk.tiscali.com/F2S/$F2S-NILDRAM-ACCEPTED/f2s-temporary-group/85.211.229.155
X-SBRS: None
X-RemoteIP: 85.211.229.155
X-IP-MAIL-FROM: simon@2ndquadrant.com
X-IP-BHB: Once
X-IronPort-Anti-Spam-Filtered: true
X-IronPort-Anti-Spam-Result: AvoAANB+hEhV0+Wb/2dsb2JhbAAIr0g
X-IronPort-AV: E=Sophos;i="4.31,225,1215385200";
   d="scan'208";a="4903510"
X-IP-Direction: IN
Received: from 85-211-229-155.dyn.gotadsl.co.uk (HELO [192.168.0.3])
	([85.211.229.155])
	by smtp.f2s.tiscali.co.uk with ESMTP; 21 Jul 2008 20:20:22 +0100
Subject: Re: pg_dump additional options for performance
From: Simon Riggs <simon@2ndquadrant.com>
To: Stephen Frost <sfrost@snowman.net>
Cc: pgsql-patches@postgresql.org
In-Reply-To: <20080721114639.GE18846@tamriel.snowman.net>
References: <20080720030749.GA18846@tamriel.snowman.net>
	<1216529229.19656.835.camel@ebony.2ndQuadrant>
	<1216535862.19656.845.camel@ebony.2ndQuadrant>
	<20080720214335.GB18846@tamriel.snowman.net>
	<1216591180.19656.848.camel@ebony.2ndQuadrant>
	<20080721011829.GC18846@tamriel.snowman.net>
	<1216620687.19656.860.camel@ebony.2ndQuadrant>
	<20080721114639.GE18846@tamriel.snowman.net>
Content-Type: text/plain
Date: Mon, 21 Jul 2008 20:26:38 +0100
Message-Id: <1216668398.3894.3.camel@ebony.2ndQuadrant>
Mime-Version: 1.0
X-Mailer: Evolution 2.12.0 
Content-Transfer-Encoding: 7bit
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: 200807/210
X-Sequence-Number: 6904


On Mon, 2008-07-21 at 07:46 -0400, Stephen Frost wrote:
> * Simon Riggs (simon@2ndquadrant.com) wrote:
> > The options split the dump into 3 parts that's all: before the load, the
> > load and after the load.
> > 
> > --schema-pre-load says
> > "Dumps exactly what <option>--schema-only</> would dump, but only those
> > statements before the data load."
> > 
> > What is it you are suggesting? I'm unclear.
> 
> That part is fine, the problem is that elsewhere in the documentation
> (patch line starting ~774 before, ~797 after, to the pg_dump.sgml) you
> change it to be "objects required before data loading", which isn't the
> same.

OK, gotcha now - will change that. I thought you might mean something
about changing the output itself.

-- 
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support