cstore_fdw 1.3 released

Hadi Moshayedi Jul 30, 2015

About Citus

Citus is a distributed database that scales out PostgreSQL. An extension to Postgres, Citus is available as open source, as on-prem software, and as a fully-managed database as a service.

Sign up for our newsletter

Enjoy what you're reading? Sign-up to our newsletter to stay informed:

Other Recent Posts

Migrating from single-node Postgres to Citus How Citus works (a look at dynamic executors) Citus 7: Transactions, Framework Integration, and Postgres 10 More Articles

Like our blog, or have a question about Citus? Join us on Slack for a chat :)

Citus Data is excited to announce the release of cstore_fdw 1.3. cstore_fdw is an open source columnar store extension for PostgreSQL that compresses your database tables and reduces disk I/O.

cstore_fdw Changes

The changes in this release include:

  • ALTER FOREIGN TABLE ADD/DROP COLUMN ... support. You can now add/drop columns on existing cstore tables. Default values on newly added columns are also supported with some restrictions.
  • Improved COPY FROM support. Column references in the COPY command is now supported. You can now specify list of columns to be copied from a file to a cstore table.
  • Query performance improvements. Table row count estimation works better which allows the query planner to better prepare query plans.
  • (Fix) Whole row references. You can now use row references in function calls like SELECT to_json(*) FROM cstore_table.
  • (Fix) Insert concurrency. Deadlock issue during concurrent insert is resolved.

For installation and update steps, you can view the instructions on the cstore_fdw page on GitHub.

Got questions?

If you have questions or feedback for cstore_fdw, please contact us using the cstore-users Google group.

If you discover an issue when using cstore_fdw, please submit it to cstore_fdw’s issue tracker on GitHub.

Further information about cstore_fdw is available on our website, where you can also find information on ways to contact us with questions.

← Next article Previous article →