Further, because pgbench writes many zero values to fixed length
columns, gzip can achieve better compression. There're another
suggestion to test with longer checkpoint interval. I will post the
result.
Thanks.
Martijn van Oosterhout wrote:
> 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,
--
Koichi Suzuki