From: Saranya Sivakumar <sarlavk@yahoo.com>
To: pgsqlperform <pgsql-performance@postgresql.org>
To: pgsqlnovice <pgsql-novice@postgresql.org>
Subject: 7.3.2 pg_restore very slow
Date: Sun, 6 Aug 2006 09:54:38 -0700 (PDT)
Message-ID: <20060806165438.35459.qmail@web51307.mail.yahoo.com> (raw)
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.
I have tried this same procedure to restore a full copy, but using 8.1(pg_dump and pg_restore) on a different server and that process took only 2 hours for the same database. But we are unable to migrate to 8.1 at this point and stuck with 7.3.2.
I use a script to dump/restore. I can send the same if that information is needed.
Please give me some pointers on what else I should be looking at to reduce the restore time using 7.3.2 version.
Thanks,
Sincerely,
Saranya Sivakumar
---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2ยข/min or less.
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: sarlavk@yahoo.com, pgsql-novice@postgresql.org
Subject: Re: 7.3.2 pg_restore very slow
In-Reply-To: <20060806165438.35459.qmail@web51307.mail.yahoo.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