Scalable Open Source PostgreSQL-based Database Cluster

postgres-xl Features:

  • Fully ACID
  • Open Source
  • Cluster-wide Consistency
  • Multi-tenant Security
  • PostgreSQL-based

 
Workloads:
 

  • OLAP with MPP Parallelism
  • Online Transaction Processing
  • Mixed
  • Operational Data Store
  • Key-value including JSON

Postgres-XL is an all-purpose fully ACID open source scale-out SQL database solution.

There are a wide variety of use cases for Postgres-XL:

  • Business Intelligence / Big Data Analytics

Postgres-XL has built-in MPP (Massively Parallel Processing) capability, with intelligent query planning, allowing you to use the familiar SQL language for handling queries over large data sets.
 

  • Web 2.0

The data tier is typically the hardest part in scaling infrastructure. Postgres-XL allows for database scaling while preventing the database from becoming a bottleneck for applications, whether for Content Management Systems, or eCommerce websites.
 

  • Legacy Applications

If hardware limits what a database can handle on a single server, Postgres-XL enables scale out across multiple nodes.
 

  • New Applications

Right-scale new applications to plan for future growth by using Postgres-XL. One could also use regular PostgreSQL, and migrate to Postgres-XL later as the database activity increases.
 
For more information about the overall architecture, please see Overview.