Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id D3BB42E004C
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 20 Feb 2008 10:14:25 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 21923-05 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 20 Feb 2008 10:14:13 -0400 (AST)
Received: from oxford.xeocode.com (unknown [87.127.95.194])
	by postgresql.org (Postfix) with ESMTP id A9E442E005C
	for <pgsql-performance@postgresql.org>;
	Wed, 20 Feb 2008 10:14:21 -0400 (AST)
Received: from localhost ([127.0.0.1] helo=oxford.xeocode.com)
	by oxford.xeocode.com with esmtp (Exim 4.69)
	(envelope-from <stark@enterprisedb.com>)
	id 1JRpiA-0007iz-0G; Wed, 20 Feb 2008 14:14:14 +0000
To: "Douglas J Hunley" <doug@hunley.homeip.net>
Cc: "Erik Jones" <erik@myemma.com>, "Jeff" <threshar@threshar.is-a-geek.com>,
	"Tom Lane" <tgl@sss.pgh.pa.us>,  "Richard Huxton" <dev@archonet.com>,
	<pgsql-performance@postgresql.org>
Subject: Re: 7 hrs for a pg_restore?
In-Reply-To: <200802200826.38611.doug@hunley.homeip.net> (Douglas J. Hunley's
	message of "Wed\, 20 Feb 2008 08\:26\:38 -0500")
User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux)
X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX.performance" 4324)
References: <200802191303.58840.doug@hunley.homeip.net>
	<200802191555.43340.doug@hunley.homeip.net>
	<080DA59E-2C02-4370-8584-FA7C8CC008B0@myemma.com>
	<200802200826.38611.doug@hunley.homeip.net>
From: Gregory Stark <stark@enterprisedb.com>
Organization: EnterpriseDB
Date: Wed, 20 Feb 2008 14:14:13 +0000
Message-ID: <874pc3ww96.fsf@oxford.xeocode.com>
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-Archive-Number: 200802/246
X-Sequence-Number: 28788

"Douglas J Hunley" <doug@hunley.homeip.net> writes:

> On Tuesday 19 February 2008 16:32:02 Erik Jones wrote:
>> pg_restore is a postgres client app that uses libpq to connect and, =A0
>> thus, will pick up anything in your $PGOPTIONS env variable. =A0So,
>>
>> PGOPTONS=3D"-c maintenance_work_mem=3D512MB" && pg_restore ....
>
> now that's just plain cool
>
> /me updates our wiki

I would suggest leaving out the && which only obfuscate what's going on her=
e.

PGOPTIONS=3D... pg_restore ...

would work just as well and be clearer about what's going on.

--=20
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's Slony Replication support!