Citus Data is pleased to announce the release of the open source pg_shard 1.2 extension for creating a scalable PostgreSQL cluster on commodity physical or virtual servers. Release notes can be found on the Citus Data blog. A recent blog post describes how to scale PostgreSQL on Amazon RDS using pg_shard. Significant enhancements in this release include:
· Full CitusDB integration — Distribution metadata is always in sync with CitusDB
· Better type support — Partition by enumeration or composite types
· Planning improvements — Improved internal metadata locking and function checking
· Usability enhancements — Better validations and error messages during use
We are also pleased to announce the release of the open source cstore_fdw 1.3 extension for creating columnar PostgreSQL. Release notes can be found on the Citus Data blog. Significant enhancements 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.
We are also pleased to announce the release of CitusDB 4.1. Release notes are available on the Citus Data blog.
Terry
Terry Erisman
Citus Data
--------
