Log In - Home Page

Patch: INSERT...ON DUPLICATE KEY LOCK FOR UPDATE

Edit Patch - Move To Another CommitFest - Delete Patch

CommitFest 2014-01
Topic SQL Commands
Patch Status Returned with Feedback
Author Peter Geoghegan
Reviewers Heikki Linnakangas
Committer Nobody
Close Date 2014-02-10
Comments
Patch by pgeoghegan on 2013-08-30 10:15:55 PM: Initial version.
Patch by pgeoghegan on 2013-09-09 05:23:50 AM: INSERT...ON DUPLICATE KEY LOCK FOR UPDATE revision
Patch by pgeoghegan on 2013-09-11 05:26:40 AM: v3 of patch. Addresses some deadlocking issues in new LWLock infrastructure.
Comment by rhaas on 2013-10-09 06:25:17 PM: summary of previous discussions
Patch by pgeoghegan on 2013-10-14 04:18:35 AM: V4. Contains convenient special-case tweak to conventional MVCC.
Review by heikki on 2013-11-18 04:45:07 PM: Can we make this work with exclusion constraints?
Comment by pgeoghegan on 2013-11-26 12:02:29 AM: Some concerns about livelocking with the approach Heikki suggested.
Patch by pgeoghegan on 2013-12-20 04:07:48 AM: Concerns with unprincipled deadlocking persist
Patch by pgeoghegan on 2013-12-29 07:26:06 AM: v5 of patch (btree value locking "speculative insertion" approach), with only heavyweight locks held across complex operations
Patch by pgeoghegan on 2014-01-03 10:58:01 PM: v6 of patch, with minor bug fixes and promising performance optimization.
Patch by pgeoghegan on 2014-01-08 04:48:10 AM: v7 of patch, fixing issues relating to visibility. Also includes miscellaneous polishing.
Comment by pgeoghegan on 2014-01-10 03:41:29 AM: Summary of current situation. Benchmark that measures extended heavyweight page locking overhead.
Comment by petere on 2014-01-11 07:23:59 PM: build OK: http://pgci.eisentraut.org/jenkins/job/postgresql_commitfest_world/307/

Add Comment

Please log in to comment on this patch.