[SERVER-67367] Make ColumnIndex workload runnable without feature flag Created: 17/Jun/22  Updated: 16/Mar/23  Resolved: 16/Mar/23

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

Type: Improvement Priority: Major - P3
Reporter: Zixuan Zhuang Assignee: Backlog - Query Execution
Resolution: Won't Do Votes: 0
Labels: pm2697-m4
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-66900 Add a classic-engine variant to sys-perf Closed
Assigned Teams:
Query Execution
Participants:
Story Points: 5

 Description   

In order to setup the baseline, it would be great if column index workload (column_store_index_charts_events_1G, and ColumnStoreIndex.yml Genny file) to run without the feature flag.

See discussion here



 Comments   
Comment by Mihai Andrei [ 16/Mar/23 ]

Electing not to do this work because we are no longer doing performance infrastructure setup for this project; please reopen if there's something I'm missing here!

Comment by Ethan Zhang (Inactive) [ 23/Jun/22 ]

Running the coll scan portion only in classical would require a separate workload I think since the current workload would set the server parameter in the setup phase.

Comment by Ian Boros [ 21/Jun/22 ]

Note that the test already runs the queries using a collection scan and column scan (see here), so the queries should work against the classic engine. I'm not sure how easy/hard it is to only run the coll scan portion of the test in genny.

Comment by Kyle Suarez [ 21/Jun/22 ]

charlie.swanson@mongodb.com and ian.boros@mongodb.com, do you think this ticket would be straightforward to do, or would we need to do some tweaking / adapting of the queries so that they work against the classic engine? This would give us the ability to establish a classic engine baseline perf and then compare the column indexes perf gain on top of it.

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