Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance of pg_dump on PGSQL 8.0 - Mailing list pgsql-performance

From John Vincent
Subject Re: Performance of pg_dump on PGSQL 8.0
Date
Msg-id c841561b0606141416w3c5cee35mc05d219700027755@mail.gmail.com
Whole thread Raw
In response to Re: Performance of pg_dump on PGSQL 8.0  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-performance
Tree view
time gzip -6 claDW_PGSQL.test.bak

real    3m4.360s
user    1m22.090s
sys     0m6.050s

Which is still less time than it would take to do a compressed pg_dump.

On 6/14/06, Scott Marlowe <smarlowe@g2switchworks.com> wrote:
How long does gzip take to compress this backup?

On Wed, 2006-06-14 at 15:59, John Vincent wrote:
> Okay I did another test dumping using the uncompressed backup on the
> system unloaded and the time dropped down to 8m for the backup.
> There's still the size issue to contend with but as I said, I've got a
> fair bit of space left on the SAN to work with.

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Performance of pg_dump on PGSQL 8.0
Next
From: "John Vincent"
Date:
Subject: Re: Performance of pg_dump on PGSQL 8.0