Re: [WIP] Performance Improvement by reducing WAL for Update Operation

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
Cc: 'Jesper Krogh' <jesper(at)krogh(dot)cc>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [WIP] Performance Improvement by reducing WAL for Update Operation
Date: 2012-08-23 20:41:51
Message-ID: 20120823204151.GD5971@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Aug 22, 2012 at 07:38:33PM +0530, Amit Kapila wrote:
> I had made sure no full_page_write happens by making checkpoint interval and
> checkpoints segments longer.
>
>
>
> Original code - 1.8G Modified code - 1.1G Diff - 63% reduction, incase of
> fill factor 100.
> Original code - 1.6G Modified code - 1.1G Diff - 45% reduction, incase of
> fill factor 80.
>
>
>
> I am still in process of collecting synchronous commit mode on data.

Wow, that sounds promising.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2012-08-23 21:03:36 Re: Is this an appropriate item?
Previous Message Alvaro Herrera 2012-08-23 20:07:02 pg_upgrade's exec_prog() coding improvement