Re:Compressing PostgreSQL JSONB data 12x using cstore_fdw
by ozgune on Tuesday May 05, 2015 @02:23PM
(#9494043)
(Ozgun from Citus Data)
Sure, we'd be interested in running more numbers. If you have example data sets in mind, could you share them with us?
For clarification, we picked this data set for several reasons. The data set was real, sizeable, publicly available, and it became highly referenced in PostgreSQL's JSON/JSONB development:
Re:Compressing PostgreSQL JSONB data 12x using cstore_fdw
by ddorian43 on Thursday May 14, 2015 @02:40PM
(#9546779)
Can you explain HOW are you compressing the json data? Ex, is it just block-pgzip-compress? Or are you exploding each jsonb-field as a separate file like with normal columns ?
Sure, we'd be interested in running more numbers. If you have example data sets in mind, could you share them with us?
For clarification, we picked this data set for several reasons. The data set was real, sizeable, publicly available, and it became highly referenced in PostgreSQL's JSON/JSONB development:
http://www.pgcon.org/2014/schedule/attachments/328_9.4json.p...
http://www.pgcon.org/2014/schedule/attachments/313_xml-hstor...
http://blog.2ndquadrant.com/jsonb-type-performance-postgresq...
http://www.pgcon.org/2014/schedule/attachments/318_pgcon-201...