| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Amit kapila <amit(dot)kapila(at)huawei(dot)com> |
| Cc: | Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, "hlinnakangas(at)vmware(dot)com" <hlinnakangas(at)vmware(dot)com>, "noah(at)leadboat(dot)com" <noah(at)leadboat(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Performance Improvement by reducing WAL for Update Operation |
| Date: | 2013-01-09 11:26:51 |
| Message-ID: | CA+U5nM+E-+UV2X3qrfiFjXFbenxL+aWyNMW0Lfp24qVLnBJ+ug@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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?
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2013-01-09 11:27:08 | [PATCH] unified frontend support for pg_malloc et al and palloc/pfree mulation (was xlogreader-v4) |
| Previous Message | Simon Riggs | 2013-01-09 11:22:06 | Re: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap [Review] |