Log In - Home Page

Patch: Performance Improvement by reducing WAL for Update Operation

Edit Patch - Move To Another CommitFest - Delete Patch

CommitFest 2014-01
Topic Performance
Patch Status Committed
Author Amit Kapila, Hari Babu
Reviewers Robert Haas, Heikki Linnakangas
Committer Heikki Linnakangas
Close Date 2014-03-12
Patch by haribabu on 2013-09-06 07:25:49 AM: Initial version.
Comment by petere on 2013-12-02 09:35:18 PM: thread contains various reviews, comments, discussion ongoing
Patch by amitkapila on 2013-12-06 06:35:33 AM: patch using chunk wise approach for delta-encoding, needs review of approach before proceeding further.
Comment by petere on 2013-12-11 10:13:34 PM: build unstable: http://pgci.eisentraut.org/jenkins/job/postgresql_commitfest_world/278/
Patch by amitkapila on 2013-12-15 07:18:04 AM: Fixed regression failures and modified few comments.
Patch by amitkapila on 2014-01-11 06:47:28 AM: Provide an option to specify wal compression for table and implementation of decoding for rabin's encoding.
Patch by amitkapila on 2014-02-01 11:37:40 AM: Updated Patches for chunkwise and byte-by-byte encoding for WAL.
Patch by amitkapila on 2014-02-05 05:01:04 AM: updated patch to form history data by traversing old tuple from end and optimizations in find match for breaking the loop based on good match concept similar to pglz. CPU usage for worst cases have improved with this patch.
Review by andresfreund on 2014-02-15 02:51:41 PM: Some minor code issues.
Patch by amitkapila on 2014-02-17 03:33:34 AM: Updated patch for fixing issues of prefix/suffix approach, fixed comments by Andres and some optimisations.

Add Comment

Please log in to comment on this patch.