From: Jesper Krogh [mailto:jes...@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.