Room: Medici I
cstore_fdw is an open source columnar store by Citus Data for PostgreSQL. Its file layout is based on the Optimized Row Columnar (ORC) format, which brings the following benefits:
We developed cstore_fdw using the foreign data wrapper framework. cstore_fdw uses PostgreSQL’s binary data format for storing values, and you can use every data type supported by PostgreSQL. You can use the same SQL syntax that PostgreSQL provides to query cstore_fdw tables.
In the benchmarks we did on TPC-H data, most queries saw a performance improvement of 20%-30%. When we enabled skip-indexes by sorting the input data, we saw a further ~30% performance improvement.