Re:How We Built a Vectorized SQL Engine
by qaq on Monday November 11, 2019 @02:59PM
(#21508293)
Didn't CockroachDB target OLTP workloads? What would the write performance be like for a columnar store for OLTP workload?
[ Parent
| on HN ]
Re:How We Built a Vectorized SQL Engine
by asubiotto on Monday November 11, 2019 @03:32PM
(#21508582)
CockroachDB does target OLTP workloads. Note that the vectorized SQL engine covered in this blog post is execution-only (and used only for queries that operate on many rows). The storage layer remains row-oriented so the write performance is not affected. Rows are columnarized before processing by the execution engine.