| Postgres-XL | |
|---|---|
 | |
| Type | Distributed relational database management system |
| License | PostgreSQL License[1] |
| Website | www |
| Repository | git |
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
editReferences
edit- ^ "Frequently Asked Questions - Postgres-XL". www.postgres-xl.org. Archived from the original on 2019-04-07. Retrieved 2017-05-30.
- ^ "Frequently Asked Questions". Postgres-XL. Archived from the original on 7 April 2019. Retrieved 31 May 2017.
- ^ "Postgres-XL git repository". git.postgresql.org. 2018-10-12. Archived from the original on 2024-07-15. Retrieved 2024-06-26.
- ^ a b "A Brief History of PostgreSQL: Postgres-XL". Postgres-XL documentation. Archived from the original on 7 April 2019. Retrieved 31 May 2017.
- ^ Butler, Brandon (4 June 2014). "10 of the most useful cloud databases". Network World. Archived from the original on December 26, 2015.
- ^ a b Clark, Jack (10 October 2013). "TransLattice gobbles StormDB upstart for Postgres threesome". The Register. Archived from the original on 7 April 2019. Retrieved 30 May 2017.
- ^ Harris, Derrick (9 October 2013). "Cloud database consolidation as TransLattice buys StormDB". Gigaom. Archived from the original on 7 April 2019. Retrieved 30 May 2017.
- ^ Clark, Jack (13 May 2014). "'Behold my creation: Postgres-XL' bellows TransLattice". The Register. Archived from the original on 7 April 2019. Retrieved 30 May 2017.
- ^ Harris, Derrick (13 May 2014). "Database vendor open sources Postgres-XL for scale-out workloads". Gigaom. Archived from the original on 7 April 2019. Retrieved 30 May 2017.
- ^ "TransLattice Unveils Postgres-XL Open Source Database for OLTP and Big Data Analytics". Database Trends and Applications. 16 May 2014. Archived from the original on 12 September 2017. Retrieved 30 May 2017.
- ^ a b Baker, Jason (13 May 2014). "Postgres-XL released to tackle big data analytics and more". Opensource.com. Archived from the original on 19 March 2016. Retrieved 30 May 2017.
- ^ Riggs, Simon; Ciolli, Gianni; Krosing, Hannu; Bartolini, Gabriele (30 April 2015). PostgreSQL 9 Administration Cookbook - Second Edition. Packt Publishing Ltd. p. 418. ISBN 9781849519076.
