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.