Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump performance? - Mailing list pgsql-performance

From Jesper Krogh
Subject Re: pg_dump performance?
Date
Msg-id cev3i4$jq8$1@sea.gmane.org
Whole thread Raw
In response to pg_dump performance?  (Jesper Krogh <jesper@krogh.cc>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: pg_dump performance?
Next
From: Gaetano Mendola
Date:
Subject: Re: Tuning queries on large database