PostgreSQL Community Participation

EnterpriseDB is deeply involved with and committed to the PostgreSQL community with the goal of constantly improving and building upon the software. EDB is also active in promoting and facilitating the adoption of PostgreSQL and related products worldwide, contributing to PostgreSQL every year since 2006.

Contributions to PostgreSQL

Pluggable storage infrastructure
Parallel processing infrastructure
Query parallelism support for index scans, bitmap scans, merge joins and optimizations when the data is recombined
Better parallel query for some UNION [ALL] cases
Parallel hash joins
Sorting, in-memory hash, concurrency locking performance improvements
Trigger transition tables for improved performance
Crash safe and WAL enabled hash indexes
Sharding preparation with push down of joins and aggregate functions to remote servers (postgres_fdw)
pg_prewarm contrib module
ALTER SYSTEM SET command

Materialized views
JSON data type
Unlogged tables
Index only scans
Linear read scaling to 64 cores
Free space map auto-tuning
Heap only tuples (HOT)
StackBuilder enabling the distribution of PostgreSQL ecosystem components
Provide and host the pgAdmin CI/CD infrastructure

Contributions to PostgreSQL Community Ecosystem Projects

pgAdmin - a feature rich administration and development platform
hdfs_fdw - a PostgreSQL Foreign Data Wrapper for the Hadoop Distributed File System
mongo_fdw - a PostgreSQL Foreign Data Wrapper for BSON data
mysql_fdw - a PostgreSQL Foreign Data Wrapper for MySQL

pg_catcheck - a simple tool for diagnosing system catalog corruption
pg_nosql_benchmark - a tool for benchmarking PostgreSQL (JSONB) and MongoDB (BSON)
Pgpool - a middleware between PostgreSQL servers and a PostgreSQL database client
Postgres-XC - provides a write-scalable, synchronous symmetric, transparent PostgreSQL cluster

Other Contributions

Help to maintain PostgreSQL.org
Employ key community members
Create and host freely available GUI binary installers for PostgreSQL
Provide build server and maintenance for PostgreSQL RPM packages
Host portions of the community's online infrastructure
Write freely available documentation (e.g. pgAdmin)

Sponsor worldwide PostgreSQL events like PostgreSQL Conference Europe, and PGCon
Sponsor local PG events and PG days
Answer users questions on community mailing lists
Answer questions and offer guidance for people developing new features
Test new features during the development process
Work with hardware vendors to ensure PostgreSQL performs and scales well on their platforms