cockroachdb / cockroachdb/cockroach
sql: run Join Order Benchmark in CI for regression testing
Open
C-enhancement
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
We run TPCC on a nightly basis, but we should also consider using JOIN order benchmark on a regular basis to flag any regressions
https://github.com/gregrahn/join-order-benchmark
Jira issue: CRDB-41500
Contributor guide
Research direction
Start by reviewing how the existing nightly TPCC benchmark is run in CI, then examine the linked Join Order Benchmark repository and determine how it could be integrated on a regular schedule. Done means the benchmark runs reliably in CI and exposes query-performance regressions.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, sql
- Domain
- ci-cd, databases, testing
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100