Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

pgsql-hackers by date

Next:From: Lamar OwenDate: 2000-08-01 16:52:56
Subject: Re: RPMs built for Mandrake
Previous:From: Thomas LockhartDate: 2000-08-01 16:19:07
Subject: Re: RPMs built for Mandrake

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group