Note that this overlaps with SERVER-71037.
The regressions in question:
Atlas atlas-1ozv3p-shard-0 [primary] perfreports> db.sbe_perf_latest.aggregate([{ $match: { test: {$nin: [/2KeyCommonPrefix/]}, tags: "sort", signed_percent_change_stable: {$lt: -10}, signed_z_score_change_stable: {$lt: -2}} }, {$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: -31.33664719878287,
signed_z_score_change_stable: -9.37996597220802,
test: 'Queries.SortNoLimitCollection100K_1PathKey3Components'
},
{
classification: 'regression critical',
signed_percent_change_stable: -28.76809350028948,
signed_z_score_change_stable: -8.127885070101737,
test: 'Queries.SortNoLimitCollection100K_1Key'
},
{
classification: 'regression critical',
signed_percent_change_stable: -23.500576278085703,
signed_z_score_change_stable: -7.08884511595428,
test: 'Queries.SortNoLimitCollection100K_1PathKey3Components'
},
{
classification: 'regression critical',
signed_percent_change_stable: -15.937287884970956,
signed_z_score_change_stable: -4.4965167297875,
test: 'Queries.SortNoLimitCollection100K_1PathKey3Components'
},
{
classification: 'regression critical',
signed_percent_change_stable: -15.207486056520565,
signed_z_score_change_stable: -4.192089409734391,
test: 'Queries.SortNoLimitCollection100K_1Key'
},
{
classification: 'regression critical',
signed_percent_change_stable: -14.565946597806473,
signed_z_score_change_stable: -4.021665022392767,
test: 'Queries.SortNoLimitCollection10K_1PathKey3Components'
},
{
classification: 'regression critical',
signed_percent_change_stable: -12.673300564086091,
signed_z_score_change_stable: -3.700062154123524,
test: 'Queries.SortNoLimitCollection10K_1PathKey3Components'
},
{
classification: 'regression critical',
signed_percent_change_stable: -12.784065111367966,
signed_z_score_change_stable: -3.1782241959005075,
test: 'Queries.SortNoLimitCollection10K_1PathKey3Components'
},
{
classification: 'regression critical',
signed_percent_change_stable: -16.23339505337792,
signed_z_score_change_stable: -2.671492319567669,
test: 'Queries.SortLimitHundredCollection1K_1PathKey3Components'
},
{
classification: 'regression critical',
signed_percent_change_stable: -14.032750571603458,
signed_z_score_change_stable: -2.4447480835556825,
test: 'Queries.SortLimitHundredCollection1K_1PathKey3Components'
},
{
classification: 'regression critical',
signed_percent_change_stable: -14.150219767176424,
signed_z_score_change_stable: -2.3865820307784986,
test: 'Queries.SortLimitHundredCollection1K_1PathKey3Components'
},
{
classification: 'regression critical',
signed_percent_change_stable: -13.543168184817162,
signed_z_score_change_stable: -2.3442390461063716,
test: 'Queries.SortLimitHundredCollection1K_1PathKey3Components'
}
]
- is related to
-
SERVER-71037 Investigate remaining sort regressions
-
- Closed
-
- split to
-
SERVER-73569 Improve sort performance for small arity sort keys
-
- Closed
-