X-Original-To: pgsql-novice-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 484F09FB285
	for <pgsql-novice-postgresql.org@postgresql.org>;
	Sun,  6 Aug 2006 13:54:48 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 93249-04 for <pgsql-novice-postgresql.org@postgresql.org>;
	Sun,  6 Aug 2006 13:54:39 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from web51307.mail.yahoo.com (web51307.mail.yahoo.com
	[206.190.38.173])
	by postgresql.org (Postfix) with SMTP id 8795E9FB292
	for <pgsql-novice@postgresql.org>; Sun,  6 Aug 2006 13:54:39 -0300 (ADT)
Received: (qmail 35461 invoked by uid 60001); 6 Aug 2006 16:54:38 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=JNpY3uIjmDD+czbN2wKOEFVM+6MPXsx7Rx4V6QlHP3LiVcmIxwkpPjbHrP1MqyWdSL5wzdN6Z614RlqLyzu4edKtbpgtaKIftZe+FyJxqmi7CnL/iR2/SvaNUD67dUQ/akKGv5p6tZM0xq9HM1vRox6ArWQyBnk2pERH1Yc5IWI=
	;
Message-ID: <20060806165438.35459.qmail@web51307.mail.yahoo.com>
Received: from [68.211.210.180] by web51307.mail.yahoo.com via HTTP;
	Sun, 06 Aug 2006 09:54:38 PDT
Date: Sun, 6 Aug 2006 09:54:38 -0700 (PDT)
From: Saranya Sivakumar <sarlavk@yahoo.com>
Subject: 7.3.2 pg_restore very slow
To: pgsqlperform <pgsql-performance@postgresql.org>,
	pgsqlnovice <pgsql-novice@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-839312057-1154883278=:35452"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=3.73 tagged_above=0 required=5
	tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS,
	HTML_30_40, HTML_MESSAGE
X-Spam-Level: ***
X-Archive-Number: 200608/41
X-Sequence-Number: 17256

--0-839312057-1154883278=:35452
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi All,
   
  I am trying to back up a full copy of one of our databases (14G) and restore it on another server. Both databases run 7.3.2 version. Though the restore completed successfully, it took 9 hours for the process to complete. The destination server runs Fedora Core 3 with 512 MB RAM and has 1 processor.  I have also deferred referential intergrity checks during the restore. I tried to tune some parameters in the config file, but it still takes 9 hours. 
   
  I have tried this same procedure to restore a full copy, but using 8.1(pg_dump and pg_restore) on a different server and that process took only 2 hours for the same database. But we are unable to migrate to 8.1 at this point and stuck with 7.3.2.
   
  I use a script to dump/restore. I can send the same if that information is needed. 
   
  Please give me some pointers on what else I should be looking at to reduce the restore time using 7.3.2 version.
   
  Thanks,
  Sincerely,
  Saranya Sivakumar
   
   
   
   
   

 		
---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.
--0-839312057-1154883278=:35452
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<div>Hi All,</div>  <div>&nbsp;</div>  <div>I am trying to back up a full copy of one of our databases (14G) and restore it on another server. Both databases run 7.3.2 version. Though the restore completed successfully, it took 9 hours for the process to complete. The destination server runs Fedora Core 3 with&nbsp;512 MB&nbsp;RAM and&nbsp;has 1 processor.&nbsp; I&nbsp;have also deferred referential intergrity checks during the restore. I tried to tune some parameters in the config file, but it still takes 9 hours. </div>  <div>&nbsp;</div>  <div>I have tried this same procedure to restore a full copy, but using 8.1(pg_dump and pg_restore)&nbsp;on a different server&nbsp;and that process took only&nbsp;2 hours for the same database. But we are unable to migrate to 8.1 at this point and stuck with 7.3.2.</div>  <div>&nbsp;</div>  <div>I use a script to dump/restore. I can send the same if that information is needed. </div>  <div>&nbsp;</div>  <div>Please give me some
 pointers on what else I should be looking at to reduce the restore time using 7.3.2 version.</div>  <div>&nbsp;</div>  <div>Thanks,</div>  <div>Sincerely,</div>  <div>Saranya Sivakumar</div>  <div>&nbsp;</div>  <div>&nbsp;</div>  <div>&nbsp;</div>  <div>&nbsp;</div>  <div>&nbsp;</div><p>&#32;
		<hr size=1>Yahoo! Messenger with Voice. <a href="http://us.rd.yahoo.com/mail_us/taglines/postman1/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com">Make PC-to-Phone Calls</a> to the US (and 30+ countries) for 2¢/min or less.
--0-839312057-1154883278=:35452--