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

Re: Performance Improvement by reducing WAL for Update Operation

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 (view raw or flat)
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


In response to

Responses

pgsql-hackers by date

Next:From: Andres FreundDate: 2013-01-09 11:27:08
Subject: [PATCH] unified frontend support for pg_malloc et al and palloc/pfree mulation (was xlogreader-v4)
Previous:From: Simon RiggsDate: 2013-01-09 11:22:06
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