From: Jesper Krogh <jesper@krogh.cc>
To: pgsql-performance@postgresql.org
Subject: pg_dump performance?
Date: Thu, 5 Aug 2004 07:08:48 +0000 (UTC)
Message-ID: <cesme0$fj9$1@sea.gmane.org> (raw)
I have a database that I should migrate from 7.3 -> 7.4.3 but pg_dump |
psql seems to take forever. (Several hours) Is there anything that can I
do to speed it up?
The databse is primary a table with 300.000 records of about 200Kbytes
each. ~ 60 GB.
This is becoming an issue with the daily backup too.. (running pg_dump
over night )
Jesper
--
./Jesper Krogh, jesper@krogh.cc
Jabber ID: jesper@jabbernet.dk
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: jesper@krogh.cc
Subject: Re: pg_dump performance?
In-Reply-To: <cesme0$fj9$1@sea.gmane.org>
* 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