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 <https://www.citusdata.com/blog/21-jason/185-announcing-pg-shard-1-2> can be found on the Citus Data blog. A recent blog post describes how to scale PostgreSQL on Amazon RDS using pg_shard <https://www.citusdata.com/blog/14-marco/178-scaling-out-postgresql-on-amazo n-rds-using-masterless-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 <https://www.citusdata.com/blog/18-hadi/184-cstore-fdw-1-3-released> 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 <https://www.citusdata.com/blog/20-sumedh/250-announcing-citusdb-41> are available on the Citus Data blog. Terry Terry Erisman Citus Data --------