[SERVER-58061] Support compound indexes on time-series metadata and measurements Created: 24/Jun/21  Updated: 04/Aug/21  Resolved: 04/Aug/21

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: New Feature Priority: Major - P3
Reporter: Gregory Wlodarek Assignee: Dan Larkin-York
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-58057 Support ascending and descending inde... Closed
Sprint: Execution Team 2021-08-09
Participants:

 Description   

Compound indexes build off the ascending and descending indexes idea. A createIndexes command on a time-series collection measurement field:

{
    createIndexes: “abc”,
    indexes: [ { key: { a : 1, b : 1 } } ]
}

will be equivalent to the following operation on the underlying buckets collection:

{
    createIndexes: “system.buckets.abc”,
    indexes: [
        { key: { control.max.a : 1, control.min.a : 1,
                 control.max.b : 1, control.min.b : 1 } }
    ]
}

Additionally, a createIndexes command on a time-series collection measurement field with both ascending and descending options:

{
    createIndexes: “abc”,
    indexes: [ { key: { a : 1, b : -1 } } ]
}

will be equivalent to the following operation on the underlying buckets collection:

{
    createIndexes: “system.buckets.abc”,
    indexes: [
        { key: { control.max.a : 1, control.min.a : 1,
                 control.min.b : -1, control.max.b : -1 } }
    ]
}



 Comments   
Comment by Githook User [ 04/Aug/21 ]

Author:

{'name': 'Dan Larkin-York', 'email': 'dan.larkin-york@mongodb.com', 'username': 'dhly-etc'}

Message: SERVER-58061 Support compound indexes on time-series metadata and measurements
Branch: master
https://github.com/mongodb/mongo/commit/d0eb0b5775e46895ab5e884db2af70632615c70e

Generated at Thu Feb 08 05:43:29 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.