News for hackers. Stuff that matters.

A comment on Columnar Storage Is Normalization. Parent comment

Re:Columnar Storage Is Normalization by gavinray on Wednesday April 22, 2026 @01:53PM (#47866946)
In theory, you don't. In practice, it's because the major SQL DBMS were architected around row-oriented storage and the technical effort to implement hybrid storage is large.

There are columnar storage engine extensions for many of the popular databases, though.

[ Parent | on HN ]
Re:Columnar Storage Is Normalization by goerch on Wednesday April 22, 2026 @02:09PM (#47867146)
Interesting: I transferred the idea of a matrix being stored row or column wise to the database world and assumed this was a more physical than theoretical feature (not a native speaker here)?

Looking forward to check out `pg_duckdb`, yes.

[ Parent | on HN ]
Re:Columnar Storage Is Normalization by gfody on Wednesday April 22, 2026 @03:15PM (#47867981)
there are hybrid engines too, so-called HTAP (as opposed to OLAP or OLTP) notable efforts are: SingleStore (commercial) and OceanBase (foss)
[ Parent | on HN ]