Postgres-XL explained

Postgres-XL
Genre:Distributed relational database management system
License:PostgreSQL License[1]

Postgres-XL is a distributed relational database management system (RDBMS) 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]

The last release of Postgres-XL was made in September 2018 and development ceased in October.[3] The website has also gone offline.

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

Postgres-XL provides cluster-wide consistent transaction snapshots[10] [11] 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.[11] 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).[12]

See also

Notes and References

  1. Web site: Frequently Asked Questions - Postgres-XL. www.postgres-xl.org.
  2. Web site: Frequently Asked Questions. Postgres-XL. en-US. 31 May 2017.
  3. Web site: 2018-10-12 . Postgres-XL git repository . 2024-06-26 . git.postgresql.org . en-US.
  4. Web site: A Brief History of PostgreSQL: Postgres-XL. Postgres-XL documentation. 31 May 2017.
  5. News: 10 of the most useful cloud databases. https://web.archive.org/web/20151226185529/http://www.networkworld.com/article/2162274/cloud-storage/cloud-computing-10-of-the-most-useful-cloud-databases.html. dead. December 26, 2015. Butler. Brandon. 4 June 2014. Network World. en.
  6. Web site: TransLattice gobbles StormDB upstart for Postgres threesome . Clark. Jack. 10 October 2013. The Register.
  7. Web site: Cloud database consolidation as TransLattice buys StormDB. Harris. Derrick. 9 October 2013. Gigaom. en-US. 30 May 2017. 7 April 2019. https://web.archive.org/web/20190407182214/https://gigaom.com/2013/10/09/cloud-database-consolidation-as-translattice-buys-stormdb/. dead.
  8. Web site: 'Behold my creation: Postgres-XL' bellows TransLattice . Clark. Jack. 13 May 2014. The Register.
  9. Web site: Database vendor open sources Postgres-XL for scale-out workloads. Harris. Derrick. 13 May 2014. Gigaom. en-US. 30 May 2017. 7 April 2019. https://web.archive.org/web/20190407180603/https://gigaom.com/2014/05/13/database-vendor-open-sources-postgres-xl-for-scale-out-workloads/. dead.
  10. News: TransLattice Unveils Postgres-XL Open Source Database for OLTP and Big Data Analytics . 16 May 2014. Database Trends and Applications. en-US.
  11. News: Postgres-XL released to tackle big data analytics and more . Baker. Jason. 13 May 2014. Opensource.com. en.
  12. Book: Riggs, Simon. PostgreSQL 9 Administration Cookbook - Second Edition . Ciolli. Gianni. Krosing. Hannu. Bartolini. Gabriele. 30 April 2015. Packt Publishing Ltd. 9781849519076. 418. en.

This article is licensed under the GNU Free Documentation License. It uses material from the Wikipedia article "Postgres-XL".

Except where otherwise indicated, Everything.Explained.Today is © Copyright 2009-2024, A B Cryer, All Rights Reserved. Cookie policy.