Software:Postgres-XL

From HandWiki
Postgres-XL
Repositorygit.postgresql.org/gitweb/?p=postgres-xl.git
TypeDistributed relational database management system
LicensePostgreSQL License[1]
Websitewww.postgres-xl.org

Postgres-XL was 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.

Some of the ideas and “smaller scale” features of Postgres-XL (parallel query, partitioning, distribution mindset) have been absorbed later by PostgreSQL. The major “Postgres-XL style” features (full shared-nothing horizontal write scale, built-in GTM, transparent multi-node sharding across the cluster in core) are not for PostgreSQL design, and the Big Data technological ecosystems followed other directions: see Citus and pg_duckdb (or pg_mooncake).

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.[6] 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.[4]

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

References

  1. ↑ "Frequently Asked Questions - Postgres-XL". http://www.postgres-xl.org/faq/. 
  2. ↑ "Frequently Asked Questions" (in en-US). http://www.postgres-xl.org/faq/. 
  3. ↑ "Postgres-XL git repository" (in en-US). 2018-10-12. https://git.postgresql.org/gitweb/?p=postgres-xl.git. 
  4. ↑ 4.0 4.1 "A Brief History of PostgreSQL: Postgres-XL". https://www.postgres-xl.org/documentation/history.html. 
  5. ↑ Butler, Brandon (4 June 2014). "10 of the most useful cloud databases" (in en). Network World. http://www.networkworld.com/article/2162274/cloud-storage/cloud-computing-10-of-the-most-useful-cloud-databases.html. 
  6. ↑ 6.0 6.1 Clark, Jack (10 October 2013). "TransLattice gobbles StormDB upstart for Postgres threesome". https://www.theregister.co.uk/2013/10/10/translattice_stormdb_acquisition/. 
  7. ↑ Harris, Derrick (9 October 2013). "Cloud database consolidation as TransLattice buys StormDB" (in en-US). https://gigaom.com/2013/10/09/cloud-database-consolidation-as-translattice-buys-stormdb/. 
  8. ↑ Clark, Jack (13 May 2014). "'Behold my creation: Postgres-XL' bellows TransLattice". https://www.theregister.co.uk/2014/05/13/translattice_postgres_xl/. 
  9. ↑ Harris, Derrick (13 May 2014). "Database vendor open sources Postgres-XL for scale-out workloads" (in en-US). https://gigaom.com/2014/05/13/database-vendor-open-sources-postgres-xl-for-scale-out-workloads/. 
  10. ↑ "TransLattice Unveils Postgres-XL Open Source Database for OLTP and Big Data Analytics" (in en-US). Database Trends and Applications. 16 May 2014. http://www.dbta.com/Editorial/News-Flashes/TransLattice-Unveils-Postgres-XL-Open-Source-Database-for-OLTP-and-Big-Data-Analytics-97064.aspx. 
  11. ↑ 11.0 11.1 Baker, Jason (13 May 2014). "Postgres-XL released to tackle big data analytics and more" (in en). Opensource.com. https://opensource.com/business/14/5/PostGres-XL-large-scale-database. 
  12. ↑ Riggs, Simon; Ciolli, Gianni; Krosing, Hannu; Bartolini, Gabriele (30 April 2015) (in en). PostgreSQL 9 Administration Cookbook - Second Edition. Packt Publishing Ltd. p. 418. ISBN 9781849519076. https://books.google.com/books?id=rYrwCAAAQBAJ&pg=PA418. 



Retrieved from "https://handwiki.org/wiki/index.php?title=Software:Postgres-XL&oldid=3979189"