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
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 |