At 12:19 PM 1/14/03 +0100, pascal bérest wrote:
>is it possible to estimate the time to restore a database from a dump ?
>the dump is 85 Mo, the base is 850 Mo, we have 512 Mo RAM and a pentium 3
>1.13 GHz.
>we are running for about 16 hours (20:00 CPU time) but it's really slow,
>and the database is actually 365 Mo restored.
Well you could look at your iostat values (to check IO bandwidth usage).
Might give you some clues, you should have a good guesstimate after a few
minutes into the restore into a test db.
Hope that helps,
Link.