Re: pg_dump slow - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: pg_dump slow
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD9ED@Herge.rcsinc.local
Whole thread Raw
In response to pg_dump slow  ("Franklin Haut" <franklin.haut@gmail.com>)
List pgsql-performance
> How are you dumping out your archive?  I confirmed unreasonably slow
dump
> with pg_dump -Z temp2 > temp2.bkp on windows 2000 server.  I normally
use
> bzip to compress my dumps.
>
> Can you measure time to dump uncompressed and also with bzip and
compare?
>
> Merlin

oops...cancel that.  I was dumping the wrong database. Dumping your
table from localhost on a dual Opteron win2k server took a few seconds
with Z=0 and Z=9.

Merlin

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: pg_dump slow
Next
From: "Qingqing Zhou"
Date:
Subject: Re: Open request for benchmarking input (fwd)