| From: | "John Vincent" <pgsql-performance(at)lusis(dot)org> |
|---|---|
| To: | "Scott Marlowe" <smarlowe(at)g2switchworks(dot)com> |
| Cc: | "PGSQL Performance" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Performance of pg_dump on PGSQL 8.0 |
| Date: | 2006-06-14 21:16:19 |
| Message-ID: | c841561b0606141416w3c5cee35mc05d219700027755@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)g2switchworks(dot)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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Vincent | 2006-06-14 21:18:14 | Re: Performance of pg_dump on PGSQL 8.0 |
| Previous Message | Jim C. Nasby | 2006-06-14 21:13:44 | Re: Performance of pg_dump on PGSQL 8.0 |