Re: [WIP] Performance Improvement by reducing WAL for Update Operation - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [WIP] Performance Improvement by reducing WAL for Update Operation
Date
Msg-id 20120823204151.GD5971@momjian.us
Whole thread Raw
In response to Re: [WIP] Performance Improvement by reducing WAL for Update Operation  (Amit Kapila <amit.kapila@huawei.com>)
Responses Re: [WIP] Performance Improvement by reducing WAL for Update Operation
List 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@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: pg_upgrade's exec_prog() coding improvement
Next
From: Bruce Momjian
Date:
Subject: Re: Is this an appropriate item?