Re: Performance Improvement by reducing WAL for Update Operation

Amit Kapila <amit.kapila@huawei.com>

From: Amit Kapila <amit.kapila@huawei.com>
To: "'Kyotaro HORIGUCHI'" <horiguchi.kyotaro@lab.ntt.co.jp>
Cc: <hlinnakangas@vmware.com>, <noah@leadboat.com>, <pgsql-hackers@postgresql.org>
Date: 2012-12-28T11:28:41Z
Lists: pgsql-hackers
On Friday, December 28, 2012 1:38 PM Kyotaro HORIGUCHI wrote:
> Hello, I saw this patch and confirmed that
> 
>  - Coding style looks good.
>  - Appliable onto HEAD.
>  - Some mis-codings are fixed.
> 
> And took the performance figures for 4 types of modification versus 2
> benchmarks.
> 
> As a whole, this patch brings very large gain in its effective range -
> e.g. updates of relatively small portions in a tuple, but negligible
> loss of performance is observed outside of its effective range on the
> test machine. I suppose the losses will be emphasized by the more
> higher performance of seq write of WAL devices


Thank you very much for the review.

With Regards,
Amit Kapila.