[SERVER-72743] Investigate set of best buy workload regressions Created: 11/Jan/23  Updated: 27/Oct/23  Resolved: 27/Mar/23

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

Type: Task Priority: Major - P3
Reporter: Mihai Andrei Assignee: Backlog - Query Execution
Resolution: Gone away Votes: 0
Labels: pm2697-m4
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Execution
Sprint: QE 2023-02-06
Participants:
Story Points: 3

 Description   

The workloads in question are as follows: 

db.sbe_perf_latest.aggregate([{ $match: {tags: "server72743"}}, {$project: {_id: 0, classification: 1, test: 1, signed_percent_change_stable: 1, signed_z_score_change_stable: 1}}])
[
  {
    classification: 'regression critical',
    signed_percent_change_stable: -12.81523020255851,
    signed_z_score_change_stable: -2.0757653225491617,
    test: 'find_project-useAgg'
  },
  {
    classification: 'regression important',
    signed_percent_change_stable: -11.522796601876351,
    signed_z_score_change_stable: -1.6296664989703145,
    test: 'find_project_6_sort_indexed_skip_limit_1-useAgg'
  },
  {
    classification: 'regression important',
    signed_percent_change_stable: -11.594318398673238,
    signed_z_score_change_stable: -1.590269825761292,
    test: 'find-useAgg'
  },
  {
    classification: 'regression important',
    signed_percent_change_stable: -11.243317088064842,
    signed_z_score_change_stable: -1.4858993740495674,
    test: 'find_project_6_sort_unindexed_skip_limit_1-useAgg'
  }
] 

 



 Comments   
Comment by David Storch [ 27/Mar/23 ]

The latest data shows that SBE is more or less on par with the classic engine for these benchmarks. Closing this ticket as "Gone Away".

Comment by Kyle Suarez [ 14/Mar/23 ]

david.storch@mongodb.com to investigate this after writing up the report in PERF-3334

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