Backup/Restore too slow

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

Responses

Browse pgsql-performance by date

  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