Re: pg_restore takes ages - Mailing list pgsql-general

From scott.marlowe
Subject Re: pg_restore takes ages
Date
Msg-id Pine.LNX.4.33.0310031428170.28179-100000@css120.ihs.com
Whole thread Raw
In response to Re: pg_restore takes ages  (Vivek Khera <khera@kcilink.com>)
List pgsql-general
On Fri, 3 Oct 2003, Vivek Khera wrote:

> >>>>> "sm" == scott marlowe <scott.marlowe> writes:
>
> sm> also, turning off fsync during the load helps a lot.  Be sure to turn it
> sm> back on when you're done of course.
>
> Only if you don't have a battery-backed cache on your RAID.  If you
> do, it won't likely make a big difference.  For me it was about 2
> seconds over a 4-hour restore.

True, very true.  Have you done the "pull the plug" test on it to make
sure it really works, by the way?


pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: pg_restore takes ages
Next
From: Ron Johnson
Date:
Subject: Re: [PERFORM] Postgres low end processing.