[ https://issues.apache.org/jira/browse/OAK-6789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16200412#comment-16200412 ]
Julian Reschke edited comment on OAK-6789 at 10/12/17 9:52 AM: --------------------------------------------------------------- trunk: [r1811931|http://svn.apache.org/r1811931] [r1811835|http://svn.apache.org/r1811835] was (Author: reschke): trunk: [r1811835|http://svn.apache.org/r1811835] > RDB: RevisionGC performance on Oracle > ------------------------------------- > > Key: OAK-6789 > URL: https://issues.apache.org/jira/browse/OAK-6789 > Project: Jackrabbit Oak > Issue Type: Bug > Components: rdbmk > Reporter: Julian Reschke > Assignee: Julian Reschke > Labels: candidate_oak_1_0, candidate_oak_1_2, candidate_oak_1_4, > candidate_oak_1_6 > Fix For: 1.8, 1.7.10 > > Attachments: OAK-6789.diff > > > In RevisionGC on Oracle, performance of deletes is bad. Using RevisionGCTest: > {noformat} > VersionGCStats{ignoredGCDueToCheckPoint=false, canceled=false, > deletedDocGCCount=92092 (of which leaf: 92000), updateResurrectedGCCount=0, > splitDocGCCount=1, intermediateSplitDocGCCount=0, iterationCount=2, > timeActive=7.429 min, timeToCollectDeletedDocs=1394 ms, > timeToCheckDeletedDocs=250.4 ms, timeToSortDocIds=374.0 us, > timeTakenToUpdateResurrectedDocs=17.00 us, timeTakenToDeleteDeletedDocs=7.399 > min, timeTakenToCollectAndDeleteSplitDocs=97.95 ms} > Performed RevisionGC in 7,429 min > {noformat} > Compared with DB2: > {noformat} > VersionGCStats{ignoredGCDueToCheckPoint=false, canceled=false, > deletedDocGCCount=96096 (of which leaf: 96000), updateResurrectedGCCount=0, > splitDocGCCount=1, intermediateSplitDocGCCount=0, iterationCount=2, > timeActive=8.240 s, timeToCollectDeletedDocs=1780 ms, > timeToCheckDeletedDocs=259.7 ms, timeToSortDocIds=237.0 us, > timeTakenToUpdateResurrectedDocs=19.00 us, timeTakenToDeleteDeletedDocs=4.552 > s, timeTakenToCollectAndDeleteSplitDocs=685.4 ms} > Performed RevisionGC in 8,243 s > {noformat} -- This message was sent by Atlassian JIRA (v6.4.14#64029)