CitusDB 4.0 Released for Massively Scaling PostgreSQL for Real-Time Applications

Citus Data is pleased to announce the general availability of CitusDB 4.0,
which is based on the new PostgreSQL 9.4 release. CitusDB is our full
featured, turnkey database solution for fully scalable, highly-available
PostgreSQL. A licensed solution, CitusDB Enterprise Edition allows you to
scale out PostgreSQL across commodity servers and also parallel process
queries across the cluster for real-time analytics on big data. Download the
Community Edition at <https://www.citusdata.com/downloads>
citusdata.com/downloads.

This release brings new functionality and performance improvements,
including:

* Support for real-time workloads - CitusDB Enterprise Edition now
integrates with pg_shard to support real-time workloads. This integration
brings together scalable analytics and low-latency writes in one system.

* Integration with PostgreSQL 9.4 to bring features like JSONB, a
faster, more efficient data type for storing JSON data; faster and smaller
GIN indexes; and many more. See
http://www.postgresql.org/docs/9.4/static/release-9-4.html for a full list
of new PostgreSQL 9.4 features.

* Re-balancing the cluster for incremental scalability and fault
tolerance - Incrementally add nodes, and uniformly distribute data and thus
traffic to those nodes. Re-replicate data from failed nodes evenly across
all the remaining ones.

* Faster query performance - A new task-assignment policy for better
in-memory workload performance. Binary serialization for data copied between
nodes, for faster performance on queries fetching a lot of data. Batching
task-assignment calls for improved performance with re-partition joins.
Fixed a bug which was causing more data than necessary to be copied over the
network.

* Improved usability - Modified \STAGE to allow loading data from any
node in the cluster, making data-loads much easier, and also allowing for a
more uniform data placement. Query throttling in the real-time executor to
prevent resource exhaustion when queries touch thousands of shards.

Further information on CitusDB can be found on the Citus Data website at
https://www.citusdata.com/citus-products/citusdb-software.

--

Terry Erisman

https://www.citusdata.com

=