[SERVER-70269] Avoid applying match filter to the unpacked document when the whole bucket matches Created: 06/Oct/22  Updated: 29/Oct/23  Resolved: 04/Nov/22

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 6.2.0-rc0, 6.0.7

Type: Task Priority: Major - P3
Reporter: Rui Liu Assignee: Rui Liu
Resolution: Fixed Votes: 0
Labels: M2
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
is depended on by COMPASS-6276 Investigate changes in SERVER-70269: ... Closed
Problem/Incident
causes SERVER-71270 Time series optimization pushes $matc... Closed
Backwards Compatibility: Fully Compatible
Backport Requested:
v6.0
Participants:
Linked BF Score: 35

 Comments   
Comment by Githook User [ 08/Jun/23 ]

Author:

{'name': 'Rui Liu', 'email': 'lriuui0x0@gmail.com', 'username': 'lriuui0x0'}

Message: SERVER-70269 Fix incorrect test assertions for timeseries $match pushdown

(cherry picked from commit 24b1ba87ae733dbb6f67e5410fe403a24ae1f822)
Branch: v6.0
https://github.com/mongodb/mongo/commit/e93beef18bbb1ccb9b087cb8142ee751a8126d4f

Comment by Githook User [ 08/Jun/23 ]

Author:

{'name': 'Rui Liu', 'email': 'rui.liu@mongodb.com', 'username': 'lriuui0x0'}

Message: SERVER-70269 Push match predicates into unpack stage

(cherry picked from commit 660a4274bf88a46734619a6606c320da30e868ab)
Branch: v6.0
https://github.com/mongodb/mongo/commit/1c1f3249b36d4768e977c81f004b48bf82a7fe25

Comment by Githook User [ 08/Dec/22 ]

Author:

{'name': 'Rui Liu', 'email': 'lriuui0x0@gmail.com', 'username': 'lriuui0x0'}

Message: SERVER-70269 Fix incorrect test assertions for timeseries $match pushdown
Branch: master
https://github.com/mongodb/mongo/commit/24b1ba87ae733dbb6f67e5410fe403a24ae1f822

Comment by Rushan Chen [ 11/Nov/22 ]

FYI, the improvements can be seen here:

https://performance-analyzer.server-tig.prod.corp.mongodb.com/perf-analyzer-viz/?evergreen_version=635fff211e2d177403ba8848&evergreen_base_version=sys_perf_f3e0726278883c893860473677e5564291d9dc7e&metrics_selection=ops_per_sec&percent_filter=0||100&z_filter=0||10

Comment by Githook User [ 02/Nov/22 ]

Author:

{'name': 'Rui Liu', 'email': 'rui.liu@mongodb.com', 'username': 'lriuui0x0'}

Message: SERVER-70269 Push match predicates into unpack stage
Branch: master
https://github.com/mongodb/mongo/commit/660a4274bf88a46734619a6606c320da30e868ab

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