Re: Config settings for large restore - Mailing list pgsql-general

From Tomasz Ostrowski
Subject Re: Config settings for large restore
Date
Msg-id 20071128115327.GA17946@batory.org.pl
Whole thread Raw
In response to Config settings for large restore  (Erik Jones <erik@myemma.com>)
List pgsql-general
On Tue, 27 Nov 2007, Erik Jones wrote:

> I'm just wondering what is considered the general wisdom on config setting
> for large pg_restore runs.

I think the first thing you can do is to "fsync=off" temporarily. But
do remember to turn this back on when you're done restoring.

Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
                                                      Winnie the Pooh

pgsql-general by date:

Previous
From: Ashish Karalkar
Date:
Subject: Re: WAL Recovery
Next
From: "Trevor Talbot"
Date:
Subject: Re: Linux v.s. Mac OS-X Performance