Thread: pg_dump performance?

pg_dump performance?

From

Jesper Krogh

Date:

06 August 2004, 03:58:26

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

Re: pg_dump performance?

From

Christopher Kings-Lynne

Date:

06 August 2004, 04:43:21

Is it the dump or the restore that's really slow?

Chris

Jesper Krogh wrote:

> 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
>

Re: pg_dump performance?

From

Jesper Krogh

Date:

06 August 2004, 05:05:22

I gmane.comp.db.postgresql.performance, skrev Christopher Kings-Lynne:
>  Is it the dump or the restore that's really slow?

Primarily the dump, it seems to be CPU-bound on the postmaster' process.

No signs on IO-bottleneck when I try to monitor with iostat or vmstat

--
./Jesper Krogh, jesper@krogh.cc
Jabber ID: jesper@jabbernet.dk