Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2EC599FA2FC for ; Fri, 22 Dec 2006 10:38:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 98413-03 for ; Fri, 22 Dec 2006 10:38:45 -0400 (AST) X-Greylist: delayed 00:06:39.168408 by SQLgrey-1.7.4 Received: from web36108.mail.mud.yahoo.com (web36108.mail.mud.yahoo.com [66.163.179.222]) by postgresql.org (Postfix) with SMTP id ACB269F939E for ; Fri, 22 Dec 2006 10:38:50 -0400 (AST) Received: (qmail 61706 invoked by uid 60001); 22 Dec 2006 14:32:09 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.ar; h=Message-ID:X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=HOnBW1yyevWAmYCV20zykoPV26xbhCd35CKiOwAhXONPjyF59geC9kA5fWpRqoVplRbcOKYBOm+ZVm+SYd+SiAY6xGL2ptyvewcFZJb72KE3Ov2UZuH/f6ppMJ/tIZLzO8lejctwln8QSKrD6eRZ4qPHjXPa3Sf2ZW43U29X5ts= ; Message-ID: <20061222143209.61704.qmail@web36108.mail.mud.yahoo.com> X-YMail-OSG: eO6yQaQVM1kdZvimkFv3_1Wl.pKuZWogp_rXvF60PJaxaNpbD.NEmVFAhqWqu92aC8cmHvNZieYrH8089f7W.XZpY62qZVHInW9ddxGkNMaTLad6PoI21S2ORKKV.bqshLwQTUzR_a4tSRk- Received: from [200.49.144.50] by web36108.mail.mud.yahoo.com via HTTP; Fri, 22 Dec 2006 14:32:09 GMT Date: Fri, 22 Dec 2006 14:32:09 +0000 (GMT) From: =?iso-8859-1?q?Sebasti=E1n=20Baioni?= Subject: Backup/Restore too slow To: Performance PostgreSQL MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-162588509-1166797929=:60023" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.353 tagged_above=0 required=5 tests=BAYES_50, HTML_10_20, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200612/525 X-Sequence-Number: 22581 --0-162588509-1166797929=:60023 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi, We have a database with one table of 10,000,000 tuples and 4 tables with 5,000,000 tuples. While in SQL Server it takes 3 minutes to restore this complete database, in PostgreSQL it takes more than 2 hours. The Backup takes 6 minutes in SQLServer and 13 minutes (which is not a problem) We are running PostgreSQL 8.1 for Windows and we are using: C:\pg_dump.exe -i -h localhost -p 5432 -U usuario -F c -b -v -f "C:\BK\file.backup" base and C:\pg_restore.exe -i -h localhost -p 5432 -U usuario -d base -O -v "C:\BK\file.backup" We use those parameters because we copied them from PGAdminIII. Is there any way to make it faster? Tanks Sebastián __________________________________________________ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ˇgratis! ˇAbrí tu cuenta ya! - http://correo.yahoo.com.ar --0-162588509-1166797929=:60023 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi,
We have a database with one table of 10,000,000 tuples and 4 tables with 5,000,000 tuples.
While in SQL Server it takes 3 minutes to restore this complete database, in PostgreSQL it takes more than 2 hours.
The Backup takes 6 minutes in SQLServer and 13 minutes (which is not a problem)

We are running PostgreSQL 8.1 for Windows and we are using:
C:\pg_dump.exe -i -h localhost -p 5432 -U usuario -F c -b -v -f "C:\BK\file.backup" base
and
C:\pg_restore.exe  -i -h localhost -p 5432 -U usuario -d base -O -v "C:\BK\file.backup"

We use those parameters because we copied them  from PGAdminIII.

Is there any way to make it faster?

Tanks
     Sebastián

__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ˇgratis!
ˇAbrí tu cuenta ya! - http://correo.yahoo.com.ar --0-162588509-1166797929=:60023--