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

  • 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