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


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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to