Postgres-XL

{{Short description|Distributed database based on PostgreSQL}}

{{Infobox software

| name = Postgres-XL

| logo = Postgres-XL logo.jpg

| repo = {{URL|1=https://git.postgresql.org/gitweb/?p=postgres-xl.git}}

| genre = Distributed relational database management system

| license = PostgreSQL License{{cite web|url=http://www.postgres-xl.org/faq/|title=Frequently Asked Questions - Postgres-XL|website=www.postgres-xl.org|access-date=2017-05-30|archive-date=2019-04-07|archive-url=https://web.archive.org/web/20190407180611/https://www.postgres-xl.org/faq/|url-status=dead}}

| website = {{URL|http://www.postgres-xl.org/}} {{Dead link|date=June 2024}}

}}

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".{{Cite web|url=http://www.postgres-xl.org/faq/|title=Frequently Asked Questions|website=Postgres-XL|language=en-US|access-date=31 May 2017|archive-date=7 April 2019|archive-url=https://web.archive.org/web/20190407180611/https://www.postgres-xl.org/faq/|url-status=dead}}

The last release of Postgres-XL was made in September 2018 and development ceased in October.{{Cite web |date=2018-10-12 |title=Postgres-XL git repository |url=https://git.postgresql.org/gitweb/?p=postgres-xl.git |access-date=2024-06-26 |website=git.postgresql.org |language=en-US}} The website has also gone offline.

Postgres-XL is based on Postgres-XC, an earlier distributed PostgreSQL system developed by NTT Data and EnterpriseDB.{{Cite web|url=https://www.postgres-xl.org/documentation/history.html|title=A Brief History of PostgreSQL: Postgres-XL|website=Postgres-XL documentation|access-date=31 May 2017|archive-date=7 April 2019|archive-url=https://web.archive.org/web/20190407180604/https://www.postgres-xl.org/documentation/history.html|url-status=dead}} In 2012, the cloud database startup StormDB{{Cite news|url=http://www.networkworld.com/article/2162274/cloud-storage/cloud-computing-10-of-the-most-useful-cloud-databases.html|archive-url=https://web.archive.org/web/20151226185529/http://www.networkworld.com/article/2162274/cloud-storage/cloud-computing-10-of-the-most-useful-cloud-databases.html|url-status=dead|archive-date=December 26, 2015|title=10 of the most useful cloud databases|last=Butler|first=Brandon|date=4 June 2014|work=Network World|language=en}} adopted Postgres-XC and developed some proprietary extensions and improvements to it. In 2013, StormDB was acquired by TransLattice,{{Cite web

|url=https://www.theregister.co.uk/2013/10/10/translattice_stormdb_acquisition/

|title=TransLattice gobbles StormDB upstart for Postgres threesome

|last=Clark|first=Jack|date=10 October 2013|website=The Register

}}{{Cite web|url=https://gigaom.com/2013/10/09/cloud-database-consolidation-as-translattice-buys-stormdb/|title=Cloud database consolidation as TransLattice buys StormDB|last=Harris|first=Derrick|date=9 October 2013|website=Gigaom|language=en-US|access-date=30 May 2017|archive-date=7 April 2019|archive-url=https://web.archive.org/web/20190407182214/https://gigaom.com/2013/10/09/cloud-database-consolidation-as-translattice-buys-stormdb/|url-status=dead}} and the improved software was open-sourced under the name "Postgres-XL" in 2014.{{Cite web

|url=https://www.theregister.co.uk/2014/05/13/translattice_postgres_xl/

|title='Behold my creation: Postgres-XL' bellows TransLattice

|last=Clark|first=Jack|date=13 May 2014|website=The Register

}}{{Cite web|url=https://gigaom.com/2014/05/13/database-vendor-open-sources-postgres-xl-for-scale-out-workloads/|title=Database vendor open sources Postgres-XL for scale-out workloads|last=Harris|first=Derrick|date=13 May 2014|website=Gigaom|language=en-US|access-date=30 May 2017|archive-date=7 April 2019|archive-url=https://web.archive.org/web/20190407180603/https://gigaom.com/2014/05/13/database-vendor-open-sources-postgres-xl-for-scale-out-workloads/|url-status=dead}} Since 2015, Postgres-XL development has also been supported by 2ndQuadrant.

Postgres-XL provides cluster-wide consistent transaction snapshots{{Cite news

|url=http://www.dbta.com/Editorial/News-Flashes/TransLattice-Unveils-Postgres-XL-Open-Source-Database-for-OLTP-and-Big-Data-Analytics-97064.aspx

|title=TransLattice Unveils Postgres-XL Open Source Database for OLTP and Big Data Analytics

|date=16 May 2014|work=Database Trends and Applications|language=en-US

}}{{Cite news

|url=https://opensource.com/business/14/5/PostGres-XL-large-scale-database

|title=Postgres-XL released to tackle big data analytics and more

|last=Baker|first=Jason|date=13 May 2014|work=Opensource.com|language=en

}} 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. 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).{{Cite book

|url=https://books.google.com/books?id=rYrwCAAAQBAJ&pg=PA418

|title=PostgreSQL 9 Administration Cookbook - Second Edition

|last=Riggs|first=Simon|last2=Ciolli|first2=Gianni|last3=Krosing|first3=Hannu|last4=Bartolini|first4=Gabriele|date=30 April 2015|publisher=Packt Publishing Ltd|isbn=9781849519076|page=418|language=en

}}