Log In - Home Page

Patch: Performance Improvement by reducing WAL for Update Operation

Edit Patch - Move To Another CommitFest - Delete Patch

CommitFest 2012-09
Topic Performance
Patch Status Returned with Feedback
Author Amit Kapila
Reviewers Noah Misch, Heikki Linnakangas
Committer Nobody
Close Date 2012-10-26
Comments
Patch by amitkapila on 2012-08-29 06:13:16 AM: Initial version. This Iniial version I have attached to refer the design of WAL reduction for Update operation. The basic idea is that write only changed columns for Update operation in WAL and then at recovery time refer the old row and WAL data to construct full row.
Patch by amitkapila on 2012-08-29 06:18:14 AM: It contains the changes for WAL optimization for HOT updates only.
Comment by amitkapila on 2012-08-29 06:21:10 AM: Test scenario's and testcases.
Patch by amitkapila on 2012-09-24 11:01:46 AM: Rebased version of patch based on latest code.
Comment by nmisch on 2012-09-27 03:47:27 AM: from Heikki: explore other delta encodings/algorithms
Review by nmisch on 2012-09-27 03:49:32 AM: TOAST problem. Diff by column or as a blob? Style points.
Patch by amitkapila on 2012-10-09 03:51:23 AM: updated patch handles all review comments raised for this patch.
Comment by nmisch on 2012-10-24 12:44:30 AM: Couldn't reproduce similar benchmark numbers
Review by nmisch on 2012-10-25 12:28:41 AM: CPU-bound performance numbers: LZ has a nontrivial penalty, delta encoding is OK
Patch by nmisch on 2012-10-26 10:34:37 PM: v3 of delta encoding variant
Review by nmisch on 2012-10-26 10:36:00 PM: Latest version does not address all prior review comments. Some new bugs.

Add Comment

Please log in to comment on this patch.