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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
