WHAT'S INSIDE
- CREATE TABLE … USING row | column | hybrid
- ALTER TABLE … SET ACCESS METHOD — convert in place
- Freshness-routed hybrid reads (designed sub-second row→column)*
- Row-vs-column parity gate: all 22 TPC-H queries byte-identical
*In development — not yet production-ready.
pick an engine per table
CREATE TABLE accounts (id INT PRIMARY KEY, owner TEXT, balance NUMERIC) USING row; -- OLTP
CREATE TABLE events (id INT, payload TEXT) USING column; -- OLAP
CREATE TABLE ticks (ts TIMESTAMPTZ, sym TEXT, px NUMERIC, vol BIGINT) USING hybrid; -- HTAP
THE REST OF THE ENGINE