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:
2012-11-14 11:26:26 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-12-07 08:58:26 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
2012-12-07 13:06:23 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-12-10 09:11:05 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
2012-12-10 12:34:52 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-12-14 09:02:07 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
2012-12-14 13:42:57 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-12-28 08:07:48 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
2012-12-28 10:21:38 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-12-28 11:27:23 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-12-28 11:55:48 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-12-28 12:03:20 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-04 13:53:58 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-04 14:33:56 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-09 08:05:02 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-09 11:26:51 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-09 12:12:38 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-11 10:40:46 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-11 10:57:45 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-11 12:30:27 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-11 12:47:34 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-11 13:49:15 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-11 13:15:14 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-11 14:24:38 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-11 14:29:49 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2013-01-11 14:34:33 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-11 17:30:16 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-11 17:42:09 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-11 18:15:10 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-11 15:57:53 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2013-01-11 17:08:14 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-11 17:39:24 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-11 18:11:11 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-11 18:53:47 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-12 03:50:10 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-12 10:15:43 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-12 14:07:26 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-12 11:06:05 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-12 14:10:45 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-12-28 11:28:41 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
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:34Subject : 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:14Subject : Re: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap [Review]
