Re:Compressing PostgreSQL JSONB data 12x using cstore_fdw
by ddorian43 on Wednesday May 06, 2015 @08:47PM
(#9502722)
Note, updatetable columnstore sucks everywhere, so I don't think so. It's only for OLAP, not OLTP (parse is oltp).
What may help @azinman is group-compression (ex: bigger pages of rows and compress the whole page, where each json-key can be repeated multiple times in a page since each page may have multiple rows). This is what happens on tokudb,hbse,hypertable,cassandra.
I'd use that as the outside end of an estimate for when the Postgres team will get updateable columnstore working.