[SERVER-71034] Investigate remaining NLJLookup regressions Created: 02/Nov/22  Updated: 27/Mar/23

Status: Open
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: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Execution
Participants:

 Description   

  {
    test: 'NLJLookup.Foreign10k_Scalar_Object5',
    signed_percent_change_stable: -27.071628041422713
  },
  {
    test: 'NLJLookup.Foreign10k_Scalar_Object5',
    signed_percent_change_stable: -26.798207222384335
  },
  {
    test: 'NLJLookup.Foreign10k_Scalar_Array8',
    signed_percent_change_stable: -22.35833260365561
  },
  {
    test: 'NLJLookup.Foreign10k_Scalar_Array8',
    signed_percent_change_stable: -22.062886281491913
  },
  {
    test: 'NLJLookup.Foreign1k_Scalar_Object5',
    signed_percent_change_stable: -14.180728207386565
  },
  {
    test: 'NLJLookup.Foreign1k_Scalar_Object5',
    signed_percent_change_stable: -14.043769077617327
  },
  {
    test: 'NLJLookup.Foreign1k_Scalar_Array8',
    signed_percent_change_stable: -12.198649907480146
  },
  {
    test: 'NLJLookup.Foreign1k_Scalar_Array8',
    signed_percent_change_stable: -11.57409631616126
  }, 



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

We have chosen to accept the remaining two NLJ $lookup regressions for the purposes of PM-2697. Moving this ticket into the follow-up project, PM-3243.

Comment by David Storch [ 27/Mar/23 ]

The most recent data suggests that only the following two related workloads are still exhibiting a regression:

    - NLJLookup.Foreign1k_Scalar_Object5
    - NLJLookup.Foreign10k_Scalar_Object5

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