Re: help with pg_dump timings - Mailing list pgsql-admin

From Arnau Rebassa Villalonga
Subject Re: help with pg_dump timings
Date
Msg-id 434FC71B.40608@andromeiberica.com
Whole thread Raw
In response to help with pg_dump timings  (Chris Hoover <revoohc@gmail.com>)
Responses Re: help with pg_dump timings  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-admin
Hi,

> Also, what -Z compression level equals the compression of gzip?  I've
> played with -Z9, but it seems to compress better than gzip (but takes a
> bit longer).

   I haven't done timing measurements but what I have noticed is that if
you use the custom format and after you try to compress the resultant
file, the size is not reduced that much, so it's not worth to spend time
compressing.

Cheers
--
Arnau



pgsql-admin by date:

Previous
From: "Nigel Bishop"
Date:
Subject: DB cluster hanging
Next
From: faeiz
Date:
Subject: PostgreSQL running in the background....