Re: pg_restore takes ages - Mailing list pgsql-general

From Vivek Khera
Subject Re: pg_restore takes ages
Date
Msg-id 16253.53726.395618.504603@yertle.int.kciLink.com
Whole thread Raw
In response to Re: pg_restore takes ages  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: pg_restore takes ages  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
>>>>> "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.

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: PostgreSQL Beta4 Tag'd and Bundle'd ...
Next
From: "Marc G. Fournier"
Date:
Subject: Re: PostgreSQL Beta4 Tag'd and Bundle'd ...