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 7891611F627D
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 10 Apr 2006 04:56:00 -0300 (ADT)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Score: 0
X-Spam-Level: 
X-Spam-Status: No, score=0 required=5 tests=[none]
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id bqiwzLzBmMGj
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 10 Apr 2006 04:55:54 -0300 (ADT)
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id 10A4811F6C60
	for <pgsql-performance@postgresql.org>;
	Mon, 10 Apr 2006 04:55:56 -0300 (ADT)
Received: from ciao.gmane.org (main.gmane.org [80.91.229.2])
	by svr4.postgresql.org (Postfix) with ESMTP id 358E45AF1A2
	for <pgsql-performance@postgresql.org>;
	Mon, 10 Apr 2006 07:55:55 +0000 (GMT)
Received: from list by ciao.gmane.org with local (Exim 4.43)
	id 1FSrFT-00030v-49
	for pgsql-performance@postgresql.org; Mon, 10 Apr 2006 09:55:47 +0200
Received: from shrek.krogh.cc ([81.7.132.92])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-performance@postgresql.org>; Mon, 10 Apr 2006 09:55:47 +0200
Received: from jesper by shrek.krogh.cc with local (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-performance@postgresql.org>; Mon, 10 Apr 2006 09:55:47 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-performance@postgresql.org
From: Jesper Krogh <jesper@krogh.cc>
Subject: Restore performance?
Date: Mon, 10 Apr 2006 07:55:33 +0000 (UTC)
Lines: 17
Message-ID: <e1d31l$2nt$1@sea.gmane.org>
X-Complaints-To: usenet@sea.gmane.org
X-Gmane-NNTP-Posting-Host: shrek.krogh.cc
User-Agent: slrn/0.9.8.1pl1 (Debian)
X-Archive-Number: 200604/192
X-Sequence-Number: 18276

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? 

The database contains quite alot of BLOB, thus the size. 

Jesper
-- 
./Jesper Krogh, jesper@krogh.cc, Jabber ID: jesper@jabbernet.dk