From: | Sebastián Baioni <sebastianbaioni(at)yahoo(dot)com(dot)ar> |
---|---|
To: | Performance PostgreSQL <pgsql-performance(at)postgresql(dot)org> |
Subject: | Backup/Restore too slow |
Date: | 2006-12-22 14:32:09 |
Message-ID: | 20061222143209.61704.qmail@web36108.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jeremy Haile | 2006-12-22 16:06:46 | URGENT: Out of disk space pg_xlog |
Previous Message | Michal Taborsky - Internet Mall | 2006-12-20 15:50:03 | Re: Question: Clustering & Load Balancing |