Re: help with pg_dump timings

From: Arnau Rebassa Villalonga <arebassa(at)andromeiberica(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: help with pg_dump timings
Date: 2005-10-14 14:56:27
Message-ID: 434FC71B.40608@andromeiberica.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Darcy Buskermolen 2005-10-14 17:59:39 Re: Monitoring database for changes - backup purposes
Previous Message Andy 2005-10-14 14:08:58 Postgres: writer process !? Time of process not to long???