Re: Re: [WIP] Performance Improvement by reducing WAL for Update Operation

Jesper Krogh <jesper@krogh.cc>

From: Jesper Krogh <jesper@krogh.cc>
To: Noah Misch <noah@leadboat.com>
Cc: Amit kapila <amit.kapila@huawei.com>, "hlinnakangas@vmware.com" <hlinnakangas@vmware.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2012-10-25T16:09:51Z
Lists: pgsql-hackers
> Naturally, there are other compression and delta encoding schemes.  Does
> anyone feel the need to explore further alternatives?
> 
> We might eventually find the need for multiple, user-selectable, WAL
> compression strategies.  I don't recommend taking that step yet.
> 

my currently implemented compression strategy is to run the wal block through gzip in the archive command. compresses pretty nicely and achieved 50%+ in my workload (generally closer to 70)

on a multi core system it will take more cpu time but on a different core and not have any effect on tps. 

General compression should probably only be applied if it have positive gain on tps you could.

Jesper