X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id DD0F511F6921
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 10 Apr 2006 05:43:42 -0300 (ADT)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Score: 0.12
X-Spam-Level: 
X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120]
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id ye-QRavlyN9f
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 10 Apr 2006 05:43:34 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.187])
	by postgresql.org (Postfix) with ESMTP id C4B3D11F6208
	for <pgsql-performance@postgresql.org>;
	Mon, 10 Apr 2006 05:43:35 -0300 (ADT)
Received: from [84.143.4.101] (helo=pse.dyndns.org)
	by mrelayeu.kundenserver.de (node=mrelayeu4) with ESMTP (Nemesis),
	id 0ML21M-1FSrzi1kIY-0003ja; Mon, 10 Apr 2006 10:43:35 +0200
Received: from pse1 ([192.168.0.3]) by pse.dyndns.org with esmtp (Exim 4.44)
	id 1FSrzf-0001bQ-ID; Mon, 10 Apr 2006 10:43:31 +0200
Message-ID: <443A1AB3.2050707@pse-consulting.de>
Date: Mon, 10 Apr 2006 10:43:31 +0200
From: Andreas Pflug <pgadmin@pse-consulting.de>
User-Agent: Mozilla Thunderbird 1.0 (X11/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Jesper Krogh <jesper@krogh.cc>
CC: pgsql-performance@postgresql.org
Subject: Re: Restore performance?
References: <e1d31l$2nt$1@sea.gmane.org>
In-Reply-To: <e1d31l$2nt$1@sea.gmane.org>
X-Enigmail-Version: 0.89.5.0
X-Enigmail-Supports: pgp-inline, pgp-mime
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Provags-ID: kundenserver.de abuse@kundenserver.de
	login:0ce7ee5c3478b8d72edd8e05ccd40b70
X-Archive-Number: 200604/195
X-Sequence-Number: 18279

Jesper Krogh wrote:
> Hi 
> 
> I'm currently upgrading a Posgresql 7.3.2 database to a
> 8.1.<something-good>
> 
> I'd run pg_dump | gzip > sqldump.gz  on the old system. That took about
> 30 hours and gave me an 90GB zipped file. Running 
> cat sqldump.gz | gunzip | psql 
> into the 8.1 database seems to take about the same time. Are there 
> any tricks I can use to speed this dump+restore process up? 

If you can have both database systems up at the same time, you could 
pg_dump | psql.

Regards,
Andreas