pg_dump and pg_restore, speed
Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
From: Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
To: Philip Warner <pjw@rhyme.com.au>
Cc: pgsql-hackers@postgresql.org
Date: 2000-08-01T16:26:55Z
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