[SERVER-78235] pushdown $group ahead of unpack with $count Created: 20/Jun/23 Updated: 29/Oct/23 Resolved: 11/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 | ||
| Issue Links: |
|
||||||||||||||||||||
| Assigned Teams: |
Query Integration
|
||||||||||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||||||||||
| Backport Requested: |
v7.0, v6.0
|
||||||||||||||||||||
| Sprint: | QE 2023-08-07 | ||||||||||||||||||||
| Participants: | |||||||||||||||||||||
| Description |
|
This is a follow-up ticket to |
| Comments |
| Comment by Gil Alon [ 30/Aug/23 ] |
|
Based on WRITING-14930 we see 139x in performance when the buckets are compact and 71x improvement in tsbs data with this optimization. Since control.count was added in 5.2, we can implement this rewrite in versions 6.0 and 7.0. |
| Comment by Githook User [ 11/Aug/23 ] |
|
Author: {'name': 'Gil Alon', 'email': 'gil.alon@mongodb.com', 'username': 'galon1'}Message: |