[SERVER-58057] Support ascending and descending indexes on time-series measurements Created: 24/Jun/21  Updated: 29/Oct/23  Resolved: 24/Jul/21

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

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

Issue Links:
Depends
Documented
is documented by DOCS-14680 DOCS-14680 Investigate changes in SER... Closed
Related
is related to SERVER-58879 listIndexes() on a time-series view d... Closed
is related to SERVER-58061 Support compound indexes on time-seri... Closed
is related to SERVER-58062 Support multikey indexes on time-seri... Closed
Backwards Compatibility: Fully Compatible
Sprint: Execution Team 2021-07-12, Execution Team 2021-07-26, Execution Team 2021-08-09
Participants:

 Description   

For ascending indexes, a createIndexes command on a time-series collection measurement field:

{
    createIndexes: “abc”,
    indexes: [ { key: { a : 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 } } ]
}

For descending indexes, a createIndexes command on a time-series collection measurement field:

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

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

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



 Comments   
Comment by Vivian Ge (Inactive) [ 06/Oct/21 ]

Updating the fixversion since branching activities occurred yesterday. This ticket will be in rc0 when it’s been triggered. For more active release information, please keep an eye on #server-release. Thank you!

Comment by Githook User [ 23/Jul/21 ]

Author:

{'name': 'Gregory Wlodarek', 'email': 'gregory.wlodarek@mongodb.com', 'username': 'GWlodarek'}

Message: SERVER-58057 Support ascending and descending indexes on time-series measurements
Branch: master
https://github.com/mongodb/mongo/commit/484192f1d6c598c926a4d74af6faccc2228bed80

Comment by Louis Williams [ 28/Jun/21 ]

Something that came to mind is that existing 5.0 indexes on "time" will only have one of these two indexes. We should consider whether 5.1 should start creating two indexes on "time" or if we should continue only creating 1 index time, along with any upgrade/downgrade implications.

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