Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group