pg_dump and pg_restore, speed

From: Kovacs Zoltan Sandor <tip(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: pg_dump and pg_restore, speed
Date: 2000-08-01 16:26:55
Message-ID: Pine.LNX.4.05.10008011812520.20839-100000@pc10.radnoti-szeged.sulinet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Can you send me the actual times? And the command you used?
I don't think my database is large enough to give you worthy data (~10000
lines). But, with the old pg_dump I got 5 secs, with the new one: 9 secs.
I used the -Fc option. The old dump was 377K, the new one is 285K.
pg_restore was fast, it was less than 1 sec. The total restoring time with
psql was 29 secs from the old dump, 86 secs from the new one. I use Linux
2.2-12.20 (RedHat 6.1), the server is a 366 MHz Intel Celeron with a
WD64AA hard disk w/ 2048K cache.

By the way, is there any statistics about the dumping/restoring time with
larger databases? Is there a faster method to backup and restore a
database than I did?

Regards, Zoltan

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Lamar Owen 2000-08-01 16:52:56 Re: RPMs built for Mandrake
Previous Message Thomas Lockhart 2000-08-01 16:19:07 Re: RPMs built for Mandrake