pg_dump performance?

From: Jesper Krogh <jesper(at)krogh(dot)cc>
To: pgsql-performance(at)postgresql(dot)org
Subject: pg_dump performance?
Date: 2004-08-05 07:08:48
Message-ID: cesme0$fj9$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)krogh(dot)cc
Jabber ID: jesper(at)jabbernet(dot)dk

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Valerie Schneider DSI/DEV 2004-08-05 08:16:59 Re: [GENERAL] Tuning queries on large database
Previous Message Pierre-Frédéric Caillaud 2004-08-05 06:40:35 Re: Performance Bottleneck