[SERVER-61949] Improve SBE $group pushdown scalability in terms of number of groups in data Created: 07/Dec/21  Updated: 27/Oct/23  Resolved: 23/Feb/23

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

Type: Task Priority: Major - P3
Reporter: Yoon Soo Kim Assignee: Backlog - Query Execution
Resolution: Gone away Votes: 0
Labels: pm2697-m3, sbe
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File Screen Shot 2021-12-07 at 12.42.11 PM.png     JPEG File Xnip2022-01-07_10-13-09.jpg    
Issue Links:
Depends
is depended on by SERVER-69993 ☂️ Umbrella ticket for SBE $group pus... Closed
Assigned Teams:
Query Execution
Sprint: QE 2022-09-19, QE 2022-10-03, QE 2022-10-17, QE 2022-10-31, QE 2022-11-14, QE 2022-11-28, QE 2022-12-12, QE 2022-12-26, QE 2023-01-09
Participants:
Story Points: 10

 Description   

As it can be seen in https://docs.google.com/spreadsheets/d/19iSNSc_lNlzWRe_0_R937E7af2ekjXPZur0sog5Fj4U/edit?usp=sharing "nGroups scalability trend" sheet, as the number of groups in data increases, SBE $group perf gain decreases dramatically.

Investigate whether this issue is legit and if so, improve the scalability in terms of number of groups in data.


Generated at Thu Feb 08 05:53:45 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.