EnterpriseDB and the PostgreSQL Community

EnterpriseDB is deeply involved with and committed to the Postgres community with the goal of constantly improving and building upon the software as well as promoting and facilitating the adoption of PostgreSQL and related products worldwide.

EnterpriseDB participates in the PostgreSQL community in many ways including:

 

Contributing to PostgreSQL product, major features including:

  • Pluggable Storage infrastucture.
  • Parallel processing infrastructure.
  • Query Parallelism support for index scans, bitmap scans, and merge joins as well as optimizations when the data is recombined, such as pre-sorting.
  • 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 reducing network traffic and improving performance (postgres_fdw).
  • pg_prewarm contrib module.
  • ALTER SYSTEM SET command.
  • Materialized Views
  • JSON data type
  • Created MySQL and Redis Foreign Data Wrappers per SQL/MED
  • Unlogged tables
  • Index Only Scans
  • Linear read scaling to 64 cores
  • Free Space Map auto-tuning
  • Full Text Search
  • 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 - Wrote and maintain most of the code in pgAdmin 4.
  • hdfs_fdw - a Postgres Foreign Data Wrapper for the Hadoop Distributed File System.
  • mongo_fdw - a Postgres Foreign Data Wrapper for BSON data.
  • mysql_fdw - a Postgres Foreign Data Wrapper for MySQL.

Other contributions

  • Help maintaining PostgreSQL.org
  • Employing key community members.
  • Creating and hosting freely available GUI binary installers for PostgreSQL.
  • Provide build server and majority of maintenance for PostgreSQL RPM packages.
  • Hosting portions of the community's online infrastructure.
  • Writing freely available documentation (e.g. pgAdmin).
  • Creating and publishing free instructional webinars (e.g. Tuning, Administration, Replication and more).
  • Sponsoring worldwide PostgreSQL events like PostgreSQL Conference Europe, and PGCon.
  • Sponsoring local events such as PGDay NY and PgDay TR.
  • Promoting press relations on behalf of PostgreSQL.
  • Creating and hosting community surveys.
  • Encouraging the growth of the PostgreSQL ecosystem with partnerships.
  • Hosting PostgreSQL forums.
  • Answering users questions on community mailing lists.
  • Answering questions and offering guidance for people developing new features.
  • Testing of new features during the development process.
  • Work with hardware vendors to ensure PostgreSQL performs and scales well on their platforms.