cstore_fdw 1.2, an open source columnar store extension for PostgreSQL, has been released by Citus Data. Widely used, cstore_fdw can significantly decrease query times for analytic queries, and compress large event datasets to save disk space.
Changes in this release include:
·Support for “INSERT INTO … SELECT …” – enables loading of data directly into cstore from regular PostgreSQL tables
·Support for “COPY TO” – enables use of the COPY command to cope the contents of a cstore table to a file
·Improved Memory Usage – as much as 90% less memory usage in some scenarios