Postgres-XL

Postgres-XL
Stable release
9.5 R1.5 / 20 April 2017 (2017-04-20)
Preview release
9.6 Alpha / 12 May 2017 (2017-05-12)
Repository git.postgresql.org/gitweb/?p=postgres-xl.git
Type Distributed relational database management system
License PostgreSQL License[1]
Website www.postgres-xl.org

Postgres-XL is a distributed relational database management system (RBDMS) software based on PostgreSQL. It aims to provide feature parity with PostgreSQL while distributing the workload over a cluster. The name "Postgres-XL" stands for "eXtensible Lattice".[2]

Postgres-XL is based on Postgres-XC, an earlier distributed PostgreSQL system developed by NTT Data and EnterpriseDB.[3] In 2012, the cloud database startup StormDB[4] adopted Postgres-XC and developed some proprietary extensions and improvements to it.[5] In 2013, StormDB was acquired by TransLattice,[5][6] and the improved software was open-sourced under the name "Postgres-XL" in 2014.[7][8] Since 2015, Postgres-XL development has also been supported by 2ndQuadrant.[3]

Postgres-XL provides cluster-wide consistent transaction snapshots[9][10] via a central Global Transaction Manager (GTM) node. It requires a fast interconnect between nodes, so Postgres-XL is not suited to geographically distributed clusters. Larger queries can be split and parallelized between multiple nodes.[10] Individual database tables can be chosen to be fully replicated across the cluster (usually for smaller tables) or sharded between separate nodes (for write scalability).[11]

See also

References

  1. ↑ "Frequently Asked Questions - Postgres-XL". www.postgres-xl.org.
  2. ↑ "Frequently Asked Questions". Postgres-XL. Retrieved 31 May 2017.
  3. 1 2 "A Brief History of PostgreSQL: Postgres-XL". Postgres-XL documentation. Retrieved 31 May 2017.
  4. ↑ Butler, Brandon (4 June 2014). "10 of the most useful cloud databases". Network World.
  5. 1 2 Clark, Jack (10 October 2013). "TransLattice gobbles StormDB upstart for Postgres threesome". The Register.
  6. ↑ Harris, Derrick (9 October 2013). "Cloud database consolidation as TransLattice buys StormDB". Gigaom.
  7. ↑ Clark, Jack (13 May 2014). "'Behold my creation: Postgres-XL' bellows TransLattice". The Register.
  8. ↑ Harris, Derrick (13 May 2014). "Database vendor open sources Postgres-XL for scale-out workloads". Gigaom.
  9. ↑ "TransLattice Unveils Postgres-XL Open Source Database for OLTP and Big Data Analytics". Database Trends and Applications. 16 May 2014.
  10. 1 2 Baker, Jason (13 May 2014). "Postgres-XL released to tackle big data analytics and more". Opensource.com.
  11. ↑ Riggs, Simon; Ciolli, Gianni; Krosing, Hannu; Bartolini, Gabriele (30 April 2015). PostgreSQL 9 Administration Cookbook - Second Edition. Packt Publishing Ltd. p. 418. ISBN 9781849519076.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.