Forks

A fork is an independent development of a software project based on another project. there are more than 20 PostgreSQL forks; PostgreSQL extensible APIs make PostgreSQL a great candidate for forking. Over the years, many groups forked PostgreSQL and contributed their findings to PostgreSQL.

HadoopDB is a hybrid between the PostgreSQL RDBMS and MapReduce technologies to target analytical workload. The following is a list of the popular PostgreSQL forks:

• Greenplum is built on the foundation of PostgreSQL. It utilizes the shared-nothing and massively parallel processing (MPP) architectures. It is used as a data warehouse and for analytical workloads. Greenplum started as proprietary software and open sourced in 2015.
• The EnterpriseDB Advanced Server is a proprietary DBMS that provides Oracle with the capability to cap the oracle fees.
• Postgres-XC (eXtensible Cluster) is a multi-master PostgreSQL cluster based on the shared-nothing architecture. It emphasis write-scalability, and provides the same APIs to applications as PostgreSQL.
• Vertica is a column-oriented database system that was started by Michael Stonebraker in 2005, and was acquisitioned by HP in 2011. Vertica reused the SQL parser, semantic analyzer, and standard SQL rewrites from the PostgreSQL implementation.
• Netzza, a popular data warehouse appliances solution, was started as a PostgreSQL fork.
• Amazon Redshift is a popular data warehouse management system based on PostgreSQL 8.0.2. It is mainly designed for OLAP applications.