[jira] Created: (DERBY-692) improve post commit committed delete handling when system crashes

["Mike Matrigali (JIRA)" <de...@db.apache.org>]

improve post commit committed delete handling when system crashes
-----------------------------------------------------------------

         Key: DERBY-692
         URL: http://issues.apache.org/jira/browse/DERBY-692
     Project: Derby
        Type: Improvement
  Components: Store  
    Versions: 10.0.2.0    
    Reporter: Mike Matrigali
    Priority: Minor


Currently  space reclamation of committed deleted rows is handled by queueing to an in memory list a queue of work
items when certain conditions are noticed.  The usual condition is that the last row on a page has been deleted.  If the
system crashes then this queue of work is lost.  Work could be done during recovery to try to recover from this.  Some
possibilities include:
1) modify redo of  delete to queue post commit if appropriate
2) modify redo of abort of insert to queue post commit if appropriate
3) moditfy redo loop which finds page that needs no redo to check if all rows are delted and queue post commit if appropriate.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira