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

From Amit Kapila
Subject Re: [WIP] Performance Improvement by reducing WAL for Update Operation
Date
Msg-id 003a01cd8012$caf3bbb0$60db3310$@kapila@huawei.com
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

From: Jesper Krogh [mailto:jesper@krogh.cc]
Sent: Wednesday, August 22, 2012 1:13 AM
On 21/08/12 16:57, Amit kapila wrote:

>>Test results:

>>1. The pgbench test run for 10min.
>> 2. The test reult is for modified pgbench (such that total row size is 1800 and updated columns are of length 300) tpc-b testcase.
>>     The result and modified pgbench code is attached with mail.

>> 3. The performance improvement shown in the m/c I have tested is quite good (more than 100% for sync commit = off).


> I cannot comment on completeness or correctness of the code, but I do think a relevant test would be
> to turn synchronous_commit on as default.


> Even though you aim at an improved performance, it would be nice to see the reduction in WAL-size
>as an effect of this patch.

Yes, I shall take care of doing both the above tests and send the report.

 

With Regards,

Amit Kapila.

pgsql-hackers by date:

Previous
From: "Wang, Chaoyong"
Date:
Subject: Re: problem when optimizing the window aggregation
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: multi-master pgbench?