| Postgres-XL | |
|---|---|
 | |
| Type | Distributed relational database management system |
| License | PostgreSQL License1 |
| 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 StormDB5 adopted Postgres-XC and developed some proprietary extensions and improvements to it.6 In 2013, StormDB was acquired by TransLattice,67 and the improved software was open-sourced under the name "Postgres-XL" in 2014.89 Since 2015, Postgres-XL development has also been supported by 2ndQuadrant.4
Postgres-XL provides cluster-wide consistent transaction snapshots1011 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
References
References
- "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 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.
- 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.
- 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.