Julian Reschke created OAK-6789:
-----------------------------------
Summary: 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
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)
