Re: Archive log compression keeping physical log available in the crash recovery - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Archive log compression keeping physical log available in the crash recovery
Date
Msg-id 20070209141105.GA20293@svana.org
Whole thread Raw
In response to Re: Archive log compression keeping physical log available in the crash recovery  (Koichi Suzuki <suzuki.koichi@oss.ntt.co.jp>)
Responses Re: Archive log compression keeping physical log available in the crash recovery  (Koichi Suzuki <suzuki.koichi@oss.ntt.co.jp>)
List pgsql-hackers
On Fri, Feb 09, 2007 at 01:00:10PM +0900, Koichi Suzuki wrote:
> Further, we can apply gzip to this archive (2.36GB).   Final size is
> 0.75GB, less than one sixtieth of the original WAL.

Note that if you were compressing on the fly, you'll have to tell gzip
to regularly flush its buffers to make sure all the data actually hits
disk. That cuts into your compression ratio...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: HOT for PostgreSQL 8.3
Next
From: Mark Cave-Ayland
Date:
Subject: Re: Hierarchical Queries--Status