[SERVER-75160] Support optimized targeted arbitrary multi deletes on a sharded timeseries collection Created: 22/Mar/23  Updated: 29/Oct/23  Resolved: 22/Apr/23

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

Type: Improvement Priority: Major - P3
Reporter: Yoon Soo Kim Assignee: Yoon Soo Kim
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-74899 Support basic arbitrary multi deletes... Closed
is related to SERVER-75424 Push down the metric predicate to pre... Closed
Backwards Compatibility: Fully Compatible
Participants:

 Description   

We should support optimized targeted arbitrary multi deletes on a sharded timeseries collection by figuring out bucket-level predicate using BucketSpec::createPredicatesOnBucketLevelField helper function so that the shard key extractor can extract proper shard keys for more queries.

For example, predicates on the time field can be translated into predicates on control.min.time since timeseries buckets collection can be sharded based on the time field.

Detailed design section: https://docs.google.com/document/d/1XQHOYrsjxsE9de_xCYyOmZ6AbtgZeXFGDz0r8aQhbbo/edit#heading=h.wk35b7m7wgzl



 Comments   
Comment by Githook User [ 22/Apr/23 ]

Author:

{'name': 'Yoonsoo Kim', 'email': 'yoonsoo.kim@mongodb.com', 'username': 'yun-soo'}

Message: SERVER-75160 Target the correct shards for arbitrary multi deletes on a sharded timeseries collection
Branch: master
https://github.com/mongodb/mongo/commit/6b038ffdb5d7d56a86ed604303fee7541e1b7bc2

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