Re: pg_restore takes ages

From: Vivek Khera <khera(at)kcilink(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_restore takes ages
Date: 2003-10-03 19:45:34
Message-ID: 16253.53726.395618.504603@yertle.int.kciLink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-10-03 19:49:15 Re: PostgreSQL Beta4 Tag'd and Bundle'd ...
Previous Message Network Administrator 2003-10-03 19:37:47 Re: online vs. hot backup (was Re: Type of application that use PostgreSQL)