time to restore a database

From: pascal bérest <lists(at)magnetophone(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: time to restore a database
Date: 2003-01-14 11:19:39
Message-ID: a05200f09ba49a22096b8@[80.236.54.8]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

hello,

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.

cheers,
pascal.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marcelo Pereira 2003-01-14 12:26:33 JDBC
Previous Message João Alfredo 2003-01-14 11:10:41 Alternative to nested transactions

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2003-01-14 12:55:29 Re: \d type queries - why not views in system catalog?!?
Previous Message Julian Scarfe 2003-01-14 09:46:16 Vacuum verbose output?