cockroachdb / cockroachdb/cockroach

sql: run Join Order Benchmark in CI for regression testing

Open
#129,334 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.