Postgres-XL 9.5 R1.4 Announced!

The Postgres-XL community is pleased to announce a security update of the software, tagged as 9.5R1.4. Besides bug fixes, this release catches up with the community release of PostgreSQL 9.5.5 including all the core server’s security & bug fixes. We encourage everyone to immediately upgrade to this latest release. Being a minor release, you only need to download the latest sources from, compile, install new binaries and restart your servers. Please note, there was a slight change to the on-disk representation of views/rules in R1.2, so if you’re upgrading from pre-1.2 release, you will need to do a fresh initdb or recreate the failing objects. Upgrading from R1.2 to a later release should not require initdb. For more details, please refer to the release notes...

Postgres-XL 9.5 R1.3 Announced!

The Postgres-XL community is pleased to announce a security update of the software, tagged as 9.5R1.3. Besides bug fixes, this release catches up with the community release of PostgreSQL 9.5.4 including all the core server’s security & bug fixes. We encourage everyone to immediately upgrade to this latest release. Being a minor release, you only need to download the latest sources from, compile, install new binaries and restart your servers. Please note, there was a slight change to the on-disk representation of views/rules in R1.2, so if you’re upgrading from pre-1.2 release, you will need to do a fresh initdb or recreate the failing objects. Upgrading from R1.2 to R1.3 should not require initdb. For more details, please refer to the release notes...

Postgres-XL 9.5 R1.2 Released!

The Postgres-XL community is pleased to announce a point release of the software, tagged as 9.5R1.2. This is a minor update to earlier 9.5R1.1 release and contains some very important bug fixes. We encourage everyone to immediately upgrade to this latest release. Being a minor release, you only need to download the latest sources from , compile, install new binaries and restart your servers. So it should be fairly straight forward. For more details, please refer to the release notes...

Announcing the availability of Postgres-XL 9.5 R1.1

The Postgres-XL community has released a new version of the software, tagged as 9.5r1.1. This is a minor update to earlier 9.5r1 release, but contains some very important bug fixes. We encourage everyone to immediately upgrade to this latest release. Being a minor release, you only need to download the latest sources from , compile, install new binaries and restart your servers. So it should be fairly straight forward. For more details, please refer to the release notes...

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...