Re: Archive log compression keeping physical log available in the crash recovery

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Koichi Suzuki <suzuki(dot)koichi(at)oss(dot)ntt(dot)co(dot)jp>
Cc: Jim Nasby <decibel(at)decibel(dot)org>, PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Archive log compression keeping physical log available in the crash recovery
Date: 2007-02-09 14:11:05
Message-ID: 20070209141105.GA20293@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Cave-Ayland 2007-02-09 14:11:23 Re: Hierarchical Queries--Status
Previous Message Heikki Linnakangas 2007-02-09 13:39:55 Re: HOT for PostgreSQL 8.3