Ben from CitusData here. At a high level columnar stores are good for analytical workloads and not great for OLTP workloads. Some reasons for this: * cstore_f

Ben from CitusData here. At a high level columnar stores are good for analytical workloads and not great for OLTP workloads. Some reasons for this: * cstore_fdw currently only supports modifying data via the COPY command. This means that UPDATE and DELETE operations aren't yet possible which limits the utility for OLTP workloads. * The skiplist indexing system works well for analytical workloads where you are aggregating or retrieving a significant number of rows but wouldn't be great for retrieving single rows.