> 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