Log In - Home Page

Patch: Performance Improvement by reducing WAL for Update Operation

Edit Patch - Move To Another CommitFest - Delete Patch

CommitFest 2013-06
Topic Performance
Patch Status Returned with Feedback
Author Amit Kapila, Hari Babu
Reviewers Greg Smith
Committer Nobody
Close Date 2013-07-22
Patch by amitkapila on 2012-11-14 11:36:39 AM: This patch reduces the WAL and improves performance for Update operation.
It writes WAL only for changed data. To achieve the same, it uses offset of attributes to recognize the attribute boundries and encodes the WAL using LZ format.
Patch by amitkapila on 2012-12-08 06:46:44 AM: updated patch to handle initial review comments by Kyotaro HORIGUCHI and fixed one defect
Patch by horiguti on 2012-12-28 08:10:26 AM: Mark this patch as 'Ready for Committer'
Patch by amitkapila on 2013-01-09 11:25:39 AM: Updated Patch to handle review comments by Simon Riggs.
Comment by simon on 2013-01-11 11:04:02 AM: Looks good. Final performance tests running to confirm benefits.
Comment by ringerc on 2013-01-18 12:18:04 PM: Author revising comments prior to commit
Patch by amitkapila on 2013-01-22 06:50:32 AM: Changes the comments in code as per suggestion from Simon Riggs.
Comment by amitkapila on 2013-01-22 06:51:38 AM: Performance readings as per latest patch.
Patch by amitkapila on 2013-01-28 01:51:08 PM: Rebased the patch as per HEAD.
Patch by amitkapila on 2013-02-01 02:07:06 PM: Updated patch for addressing encoding API design.
Comment by amitkapila on 2013-02-01 02:08:02 PM: Performace data for latest patch
Comment by amitkapila on 2013-02-06 03:13:52 AM: Performance data for synchronous_commit = on
Comment by ringerc on 2013-03-03 02:49:29 PM: Possibly trend in 1-client stats; asked author for opinion, possible big-record test.
Patch by heikki on 2013-03-05 09:29:41 PM: Performance testing and a patch using a different approach.
Patch by amitkapila on 2013-03-09 10:54:56 AM: some more optimizations and performance data based on approach suggested by heikki.
Patch by amitkapila on 2013-03-13 12:32:40 PM: Fixed defect in recovery; Performance of synchronous_commit = on and recovery.
Patch by amitkapila on 2013-03-30 02:41:17 AM: Performance data with snappy and fixed defect in LZ compression patch.
Patch by amitkapila on 2013-06-10 04:13:04 AM: Modified to store unmatched new tuple data to history.
Patch by haribabu on 2013-07-02 08:49:04 AM: Rebased patch as per latest PG LZ algorithm.
Patch by haribabu on 2013-07-19 05:48:12 AM: Latest patch
Review by gsmith on 2013-07-22 06:35:55 PM: Performance on "hundred tiny fields" cases are an issue, especially "half nulls" one.

Add Comment

Please log in to comment on this patch.