[jira] [Comment Edited] (OAK-6129) Create compound index on _sdType and _sdMaxRevTime

["Julian Reschke (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OAK-6129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15992443#comment-15992443 ] 

Julian Reschke edited comment on OAK-6129 at 5/2/17 7:02 AM:
-------------------------------------------------------------

[~mreutegg] - back then, there simply was no need, as there simply was no RDB specific {{VersionGCSupport}}. When I introduced it, I worked around the issue by using constraints on {{_id}} instead.

I'm prepared to change the DB schema, but it will require a bit of work with respect to compatibility and migration. I wouldn't rush this until we have proper test coverage for it.


was (Author: reschke):
[~mreutegg] - back then, there simply was no need, as there simply was no RDB specific VersionGCSupport. When I introduced it, I worked around the issue by using constraints on {{_id}} instead.

I'm prepared to change the DB schema, but it will require a bit of work with respect to compatibility and migration. I wouldn't rush this until we have proper test coverage for it.

> Create compound index on _sdType and _sdMaxRevTime
> --------------------------------------------------
>
>                 Key: OAK-6129
>                 URL: https://issues.apache.org/jira/browse/OAK-6129
>             Project: Jackrabbit Oak
>          Issue Type: Improvement
>          Components: mongomk
>            Reporter: Marcel Reutegger
>            Assignee: Marcel Reutegger
>             Fix For: 1.7.0, 1.8
>
>
> Replace the current index on {{_sdType}} with a partial index on {{_sdType}} and {{_sdMaxRevTime}}. This is required to run queries issued by the Revision GC efficiently. 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)