Re: time to restore a database

From: Thomas Beutin <tyrone(at)laokoon(dot)IN-Berlin(dot)DE>
To: pascal bérest <lists(at)magnetophone(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: time to restore a database
Date: 2003-01-14 17:07:13
Message-ID: 20030114180713.A9297@laokoon.bug.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi,

On Tue, Jan 14, 2003 at 12:19:39PM +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.
No idea.

> we are running for about 16 hours (20:00 CPU time) but it's really
> slow, and the database is actually 365 Mo restored.
Did You disabled fsync for restore?

so long,
-tb
--
Thomas Beutin tb(at)laokoon(dot)IN-Berlin(dot)DE
Beam me up, Scotty. There is no intelligent live down in Redmond.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-01-14 17:35:07 Re: Server error and deadlocks
Previous Message pginfo 2003-01-14 16:58:51 Wrong query execution.

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2003-01-14 17:15:41 Re: copying perms to another user
Previous Message Andrew Sullivan 2003-01-14 16:50:26 Re: Server error and deadlocks