[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: |
|
||||||||||||||||||||||||||||
| 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:
will be equivalent to the following operation on the underlying buckets collection:
For descending indexes, a createIndexes command on a time-series collection measurement field:
will be equivalent to the following operation on the underlying buckets collection:
|
| 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: |
| 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. |