Postgres Pro
Downloads
Home   >   mailing lists

pg_dump performance? - Mailing list pgsql-performance

From Jesper Krogh
Subject pg_dump performance?
Date
Msg-id cesme0$fj9$1@sea.gmane.org
Whole thread Raw
Responses Re: pg_dump performance?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Mischa Sandberg"
Date:
Subject: Re: my boss want to migrate to ORACLE
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: pg_dump performance?