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

Status: Closed
Project: Core Server
Component/s: Query Execution
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.40.33 PM.png     JPEG File Xnip2022-01-07_10-08-34.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#gid=2008213546 "nAcc scalability trend" sheet, as the number of accumulators increases, SBE $group perf gain decreases dramatically.

Investigate whether this issue is legit and if so, improve the performance.


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