Re: dump_all/restore times?

nolan(at)celery(dot)tssi(dot)com wrote:
> The dump file was about 7GB. (That seems about right based on past
<snip>
> I started the restore at 6PM last night, 18 hours later I'm hoping it is
> getting close to being done, as it has been building indexes for the past
> hour or so.
>
> The test system is quite a bit slower than the system I'm cloning, it is on
> a 133Mhz P2 vs a 2.2 Ghz Athlon, but it has a fairly fast 40 GB IDE disk
> drive.
>
> Is the amount of time it is taking within reasonable limits?

A couple of years ago I loaded a database of ~7GB on a dual ppro 200 MHz
server (with SCSI drives). I think it took about 24 hours. Based on that
experience, I'd say your 18 hours on a 133 Mhz machine is not bad.

The exact same data, later loaded onto a dual 1.4GHz pentium III server
took about an hour.

HTH,

Joe