Postgres-XL is a

distributed Distribution may refer to: Mathematics *Distribution (mathematics), generalized functions used to formulate solutions of partial differential equations *Probability distribution, the probability of a particular value or value range of a varia ...

relational database management system A relational database is a (most commonly digital) database based on the relational model of data, as proposed by E. F. Codd in 1970. A system used to maintain relational databases is a relational database management system (RDBMS). Many relatio ...

(RDBMS) software based on

PostgreSQL PostgreSQL (, ), also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the In ...

. It aims to provide feature parity with PostgreSQL while distributing the workload over a

cluster may refer to: Science and technology Astronomy * Cluster (spacecraft), constellation of four European Space Agency spacecraft * Asteroid cluster, a small asteroid family * Cluster II (spacecraft), a European Space Agency mission to study t ...

. The name "Postgres-XL" stands for "eXtensible Lattice". Postgres-XL is based on Postgres-XC, an earlier distributed PostgreSQL system developed by

NTT Data is a Japanese multinational information technology (IT) service and consulting company headquartered in Tokyo, Japan. It is a partially-owned subsidiary of Nippon Telegraph and Telephone (NTT). Japan Telegraph and Telephone Public Corporation ...

and

EnterpriseDB EnterpriseDB (EDB), a privately held company based in Massachusetts, provides software and services based on the open-source database PostgreSQL (also known as Postgres), and is one of the largest contributors to Postgres. EDB develops and inte ...

. In 2012, the

cloud database A cloud database is a database that typically runs on a cloud computing platform and access to the database is provided as-a-service. There are two common deployment models: users can run databases on the cloud independently, using a virtual machin ...

startup StormDB adopted Postgres-XC and developed some proprietary extensions and improvements to it. In 2013, StormDB was acquired by

TransLattice TransLattice is a software company based in Santa Clara, California. It geographically distributes databases and applications for enterprise, cloud and hybrid environments. TransLattice offers a NewSQL database and an application platform. Hi ...

, and the improved software was open-sourced under the name "Postgres-XL" in 2014. Since 2015, Postgres-XL development has also been supported by 2ndQuadrant. Postgres-XL provides cluster-wide consistent transaction snapshots 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).

References

External links

* {{Database-stub PostgreSQL Free database management systems Relational database management systems Distributed data stores

See also

References

External links