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 D30D211F7DB1 for ; Mon, 10 Apr 2006 06:01:46 -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 Sv-XnDVtqyZx for ; Mon, 10 Apr 2006 06:01:34 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from uproxy.gmail.com (uproxy.gmail.com [66.249.92.168]) by postgresql.org (Postfix) with ESMTP id 38D6211F6D55 for ; Mon, 10 Apr 2006 06:01:35 -0300 (ADT) Received: by uproxy.gmail.com with SMTP id c2so567273ugf for ; Mon, 10 Apr 2006 02:01:35 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:from:to:references:subject:date:mime-version:content-type:content-transfer-encoding:x-priority:x-msmail-priority:x-mailer:x-mimeole; b=ODu40VPAf/Qtnu6cW3eykzTHzrZ2oVeQtEjBpLIlB5A80UlbOtvjKk1B9LExCyk4HuWQ9Qvzp/QPxkMs+Y9sHa2E5z6tv02dlBWCh1/AjSBQPXQLo4psvUkOdmBztGKzchdUutO/uq9N6hqbmT+nPv4BKP3y1PN8d6Ui4+HFz/I= Received: by 10.66.222.15 with SMTP id u15mr3071382ugg; Mon, 10 Apr 2006 02:01:35 -0700 (PDT) Received: from maniek ( [62.148.95.123]) by mx.gmail.com with ESMTP id c1sm31051ugf.2006.04.10.02.01.33; Mon, 10 Apr 2006 02:01:35 -0700 (PDT) Message-ID: <044d01c65c7d$875ffcc0$0c67a8c0@maniek> From: =?iso-8859-2?Q?Marcin_Ma=F1k?= To: , "Jesper Krogh" References: Subject: Re: Restore performance? Date: Mon, 10 Apr 2006 11:02:40 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-Archive-Number: 200604/197 X-Sequence-Number: 18281 > 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. You could try slony - it can do almost-zero-downtime upgrades. Greetings Marcin Mank