cockroachdb / cockroachdb/cockroach
sql/schema: quantify duration and performance impact of large schema changes
Open
A-schema-changes
C-enhancement
O-schema-testing
T-sql-foundations
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
We should try to quantify how long a large schema change takes and what kinds of performance impacts we may see so we can document this better.
We can populate ~20-50K ranges/node, baseline a kv50's p99 latency, perform a schema change, and document the impact to foreground traffic as well as how long it takes. Previous testing suggested the impact is "large."
Jira issue: CRDB-40157
Epic CRDB-40071
Contributor guide
Assessment
This issue has not been assessed yet.