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:

  • Help maintaining PostgreSQL.org
  • Making major contributions to PostgreSQL product features including:
    • Parallel processing foundations.
    • 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
    • MySQL and Redis Foreign Data Wrappers for 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.
    • pl/pgsql debugger in pgAdmin.
    • Numerous new features in pgAdmin, including support for new database object types in PostgreSQL.
  • Contributing to PostgreSQL community ecosystem projects:
    • 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.
    • pg_catcheck - a simple tool for diagnosing system catalog corruption.
    • pg_nosql_benchmark - a tool for benchmarking Postgres (JSONB) and MongoDB (BSON).
    • pgAdmin
    • pgPool
    • Postgres-XC
  • Employing key community members.
  • Creating and hosting freely available GUI binary installers for PostgreSQL.
  • Creating and hosting freely available RPM installers for PostgreSQL.
  • 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 PG East, PG West, PG Europe, and PG Con.
  • 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 and Postgres Plus 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.