Re: Config settings for large restore

From: Tomasz Ostrowski <tometzky(at)batory(dot)org(dot)pl>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Cc: Erik Jones <erik(at)myemma(dot)com>
Subject: Re: Config settings for large restore
Date: 2007-11-28 11:53:31
Message-ID: 20071128115327.GA17946@batory.org.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Trevor Talbot 2007-11-28 11:55:56 Re: Linux v.s. Mac OS-X Performance
Previous Message Ashish Karalkar 2007-11-28 11:00:59 Re: WAL Recovery