Horton
Menu

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

Bruce Momjian <bruce@momjian.us>

View thread
From: Bruce Momjian <bruce@momjian.us>
To: Amit Kapila <amit.kapila@huawei.com>
Cc: 'Jesper Krogh' <jesper@krogh.cc>, pgsql-hackers@postgreSQL.org
Date: 2012-08-23T20:41:51Z
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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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