Re: pg_restore takes ages

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Vivek Khera <khera(at)kcilink(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_restore takes ages
Date: 2003-10-03 20:28:46
Message-ID: Pine.LNX.4.33.0310031428170.28179-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2003-10-03 20:42:32 Re: [PERFORM] Postgres low end processing.
Previous Message Joshua D. Drake 2003-10-03 20:05:06 Beta 4 of 7.4