Postgres-XL 9.5 R1 Released!

The Postgres-XL community is pleased to announce the 1st release of Postgres-XL 9.5. This release has been fully synced up till PostgreSQL 9.5.2.   Postgres-XL is a massively parallel database built on top of, and very closely compatible with PostgreSQL 9.5 and its set of advanced features. Postgres-XL is fully open source and many parts of it will feed back directly or indirectly into later releases of PostgreSQL, as we begin to move towards a fully parallel sharded version of core PostgreSQL. Postgres-XL is different because it supports both Business Intelligence and OLTP workloads in the same horizontally scalable server. This allows Postgres-XL to support a diverse range of workloads OLTP workloads that need write-scalability as well as read-scalability Business Intelligence requiring OLAP with massive parallelism Operational Data Store/ Central Data Backbone Distributed Key-Value store using JSONB, similar to NoSQL Internet of Things applications Mixed-workload environments Star schema style SQL queries exhibit large performance gains from massively parallel processing (MPP). Many queries show fully linear performance gains, for example a 16-node XL cluster is 16 times faster than PostgreSQL on one node. Postgres-XL is able to successfully complete the complex TPC-H business intelligence benchmark, showing its capability to address much more than basic operations. Besides proving its mettle on Business Intelligence workloads, Postgres-XL has performed remarkably well on OLTP workloads when running pgBench (based on TPC-B) benchmark. In a 4-Node (Scale: 4000) configuration, compared to PostgreSQL, XL gives up to 230% higher TPS (-70% latency comparison) for SELECT workloads and up to 130% (-56% latency comparison) for UPDATE workloads. Yet, it can scale much, much higher than even the...

Postgres-XL 9.5 R1 Beta2 Announced!

The Postgres-XL community is pleased to announce the 2nd Beta release of Postgres-XL 9.5 R1. Postgres-XL is a massively parallel database built on top of, and very closely compatible with PostgreSQL 9.5 and its set of advanced features. Postgres-XL is fully open source and many parts of it will feed back directly or indirectly into later releases of PostgreSQL, as we begin to move towards a fully parallel sharded version of core PostgreSQL. Some of the major enhancements that went into the Beta2 release are: Improve handling of Append and MergeAppend plans. They are now pushed down to the datanodes whenever possible. Add support for 3-stage aggregation for json_agg() aggregate, thus improving performance for the aggregate handling. Add support for checking status of a coordinator or datanode slave without requiring it to be started as a Hot Standby. Fix a bug in parameter handling, which was causing certain errors in plpgsql procedure execution. Correctly include the string terminator in calculating GID size, without which the GID will look corrupted and unusable after a crash recovery. Fix handling of binary data transfer for JDBC as well as libpq protocols. Add support for process level control for overriding log levels for elog messages. For a more detailed list, please look at the release notes here: http://files.postgres-xl.org/documentation/release.html Postgres-XL is available for download here: http://www.postgres-xl.org/download/ You can go through XL’s comprehensive documentation here: http://files.postgres-xl.org/documentation/index.html 2ndQuadrant has led the development of Postgres-XL 9.5, building upon the work of many others over a long period of continuous development, with easily more than 10 man years of development. We encourage users to contribute their comments and usage reports to the Postgres-XL community at...

Postgres-XL 9.5 R1 Beta1 Announced!

The Postgres-XL community is pleased to announce Postgres-XL 9.5 R1 Beta 1. Postgres-XL is a massively parallel database built on top of, and very closely compatible with PostgreSQL 9.5 and its set of advanced features. Postgres-XL is fully open source and many parts of it will feed back directly or indirectly into later releases of PostgreSQL, as we begin to move towards a fully parallel sharded version of core PostgreSQL. Postgres-XL is different because it supports both Business Intelligence and OLTP workloads in the same horizontally scalable server. This allows Postgres-XL to support a diverse range of workloads OLTP workloads that need write-scalability as well as read-scalability Business Intelligence requiring OLAP with massive parallelism Operational Data Store/ Central Data Backbone Distributed Key-Value store using JSONB, similar to NoSQL Internet of Things applications Mixed-workload environments Star schema style SQL queries exhibit large performance gains from massively parallel processing (MPP). Many queries show fully linear performance gains, for example a 16-node XL cluster is 16 times faster than PostgreSQL on one node. Postgres-XL is able to successfully complete the complex TPC-H business intelligence benchmark, showing its capability to address much more than basic operations. Postgres-XL’s High Availability functionality has also been enhanced in this release. Popular features such as BRIN indexes, JSONB and GIN index compression are fully supported, as are many popular extensions. Postgres-XL is available for download here: http://www.postgres-xl.org/download/ You can go through XL’s comprehensive documentation here: http://files.postgres-xl.org/documentation/index.html 2ndQuadrant has led the development of Postgres-XL 9.5, building upon the work of many others over a long period of continuous development, with easily more than 10 man years of development....