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

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.