[SERVER-79272] Investigate query rewrites for fixed bucketing for updates/deletes Created: 24/Jul/23  Updated: 29/Oct/23  Resolved: 17/Aug/23

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

Type: Task Priority: Major - P3
Reporter: Gil Alon Assignee: Gil Alon
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Integration
Backwards Compatibility: Fully Compatible
Sprint: QI 2023-08-07, QI 2023-08-21
Participants:

 Description   

In the updates/delete code path we call createPredicatesOnBucketLevelField which can use the fixed buckets rewrites in these places:

  1. getBucketLevelPredicateForRouting (won't apply for the optimization since this is on mongos).
  2. getPushdownPredicates() --> getMatchExprsForWrites --> ParsedDelete and ParsedUpdateBase
  3. getPushdownPredicates() --> pushdownPredicate --> 
    makeTimeseriesCreateIndexesCommand

We need to investigate if we can pass the fixedBuckets parameter to these places.



 Comments   
Comment by Githook User [ 17/Aug/23 ]

Author:

{'name': 'Gil Alon', 'email': 'gil.alon@mongodb.com', 'username': 'galon1'}

Message: SERVER-79272 Add fixed buckets match rewrites to parsed update and delete
Branch: master
https://github.com/mongodb/mongo/commit/afca7cf8032066de444f35fe2b1a989607b093b2

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