3 ms·
Very out of touch with Postgres, but is there a native column oriented table type option in Postgres so that you choose either row-based or columnar in the CREA
by chrisjc 3y ago
Very out of touch with Postgres, but is there a native column oriented table type option in Postgres so that you choose either row-based or columnar in the CREATE TABLE DDL?
- btown 3y agoI don't believe Postgres has this natively, but an alternative to OP is Citus, a Postgres extension which allows this kind of syntax. https://www.citusdata.com/blog/2021/03/06/citus-10-columnar-compression-for-postgres/ https://www.citusdata.com/blog/2021/03/06/citus-10-columnar-... EDIT: per another comment, OP is a fork of Citus Columnar!