Message-ID: <44D70E26.9020804@archonet.com>
Date: Mon, 07 Aug 2006 10:55:50 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 1.5.0.5 (X11/20060719)
MIME-Version: 1.0
To: Saranya Sivakumar <sarlavk@yahoo.com>
Cc: pgsqlperform <pgsql-performance@postgresql.org>,
	pgsqlnovice <pgsql-novice@postgresql.org>
Subject: Re: [PERFORM] 7.3.2 pg_restore very slow
References: <20060806165438.35459.qmail@web51307.mail.yahoo.com>
In-Reply-To: <20060806165438.35459.qmail@web51307.mail.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Saranya Sivakumar wrote:
> Hi All,
> 
> I am trying to back up a full copy of one of our databases (14G) and
> restore it on another server. Both databases run 7.3.2 version.
> Though the restore completed successfully, it took 9 hours for the
> process to complete. The destination server runs Fedora Core 3 with
> 512 MB RAM and has 1 processor.  I have also deferred referential
> intergrity checks during the restore. I tried to tune some parameters
> in the config file, but it still takes 9 hours.

Firstly, you should upgrade to the most recent version of 7.3.x (7.3.15) 
- that's a *lot* of bug-fixes you are missing

Then, I would temporarily disable fsync and increase sort_mem and 
checkpoint_segments. What you're trying to do is make a single process 
run as fast as possible, so allow it to grab more resources than you 
normally would.

-- 
   Richard Huxton
   Archonet Ltd