From: Richard Huxton <dev@archonet.com>
To: Saranya Sivakumar <sarlavk@yahoo.com>
Cc: pgsqlperform <pgsql-performance@postgresql.org>
Cc: pgsqlnovice <pgsql-novice@postgresql.org>
Subject: Re: [PERFORM] 7.3.2 pg_restore very slow
Date: Mon, 07 Aug 2006 10:55:50 +0100
Message-ID: <44D70E26.9020804@archonet.com> (raw)
In-Reply-To: <20060806165438.35459.qmail@web51307.mail.yahoo.com>
References: <20060806165438.35459.qmail@web51307.mail.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, sarlavk@yahoo.com, pgsql-novice@postgresql.org
Subject: Re: [PERFORM] 7.3.2 pg_restore very slow
In-Reply-To: <44D70E26.9020804@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox