Skip site navigation (1) Skip section navigation (2)

Re: Performance Improvement by reducing WAL for Update Operation

From: Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
To: "'Simon Riggs'" <simon(at)2ndQuadrant(dot)com>
Cc: "'Kyotaro HORIGUCHI'" <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, <hlinnakangas(at)vmware(dot)com>, <noah(at)leadboat(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Performance Improvement by reducing WAL for Update Operation
Date: 2013-01-09 12:12:38
Message-ID: 00b401cdee62$9e738930$db5a9b90$@kapila@huawei.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wednesday, January 09, 2013 4:57 PM Simon Riggs wrote:
> On 9 January 2013 08:05, Amit kapila <amit(dot)kapila(at)huawei(dot)com> wrote:
> 
> > Update patch contains handling of below Comments
> 
> Thanks
> 
> 
> > Test results with modified pgbench (1800 record size) on the latest
> patch:
> >
> > -Patch-             -tps(at)-c1-     -WAL(at)-c1-      -tps(at)-c2-      -
> WAL(at)-c2-
> > Head                831           4.17 GB        1416           7.13
> GB
> > WAL modification    846           2.36 GB        1712           3.31
> GB
> >
> > -Patch-             -tps(at)-c4-     -WAL(at)-c4-      -tps(at)-c8-      -
> WAL(at)-c8-
> > Head                2196          11.01 GB       2758           13.88
> GB
> > WAL modification    3295           5.87 GB       5472            9.02
> GB
> 
> And test results on normal pgbench?

As there was no gain for original pgbench as was shown in performance
readings, so I thought it is not mandatory.
However I shall run for normal pgbench as it should not lead any further dip
in normal pgbench.
Thanks for pointing.

With Regards,
Amit Kapila.





In response to

pgsql-hackers by date

Next:From: Simon RiggsDate: 2013-01-09 12:14:34
Subject: Re: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap [Review]
Previous:From: Amit KapilaDate: 2013-01-09 12:06:14
Subject: Re: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap [Review]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group