pg_shard 1.2 for Scalable PostgreSQL and cstore_fdw 1.3 for Columnar PostgreSQL Released

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

--------