postgresql

PostgreSQL Contributions

Committed to the
PostgreSQL community

EDB is deeply involved with and committed to the PostgreSQL community with the goal of constantly improving and building upon the software. We’re active in promoting the adoption of PostgreSQL and related software worldwide, contributing every year since 2006. Some of our team members have been involved with the project since its inception in 1996, and continue to play a key role in shaping its future.

Contributions to PostgreSQL

EDB has a long history of contributing to the growth and development of PostgreSQL. Here are just a few of our contributions:

Optimizing performance

  • Unlogged tables
  • Index only scans
  • Free space map auto-tuning
  • Heap only tuples (HOT)
  • Locking improvements for significantly better read and write scalability
  • Trigger transition tables for improved performance
  • pg_prewarm contrib module

Parallel Query

  • 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

Optimizing storage

  • Pluggable storage infrastructure
  • Crash safe and WAL enabled hash indexes
  • Materialized views

Hosting and packaging

  • StackBuilder enabling the distribution of PostgreSQL ecosystem components
  • Provide and host the pgAdmin CI/CD infrastructure

But wait, there’s more!

  • ALTER SYSTEM SET command
  • Original version of the JSON data type
  • Sharding preparation with push down of joins and aggregate functions to remote servers (postgres_fdw)

Even More 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 (for example, for pgAdmin)
  • Sponsor major PostgreSQL events like PostgreSQL Conference Europe and PGCon
  • Sponsor local PG events and PG days
  • Answer user 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 that PostgreSQL performs and scales well on their platforms

Contributions to PostgreSQL community ecosystem projects

pgAdmin →

Feature-rich administration and development platform

Pgpool-II →

Middleware between PostgreSQL servers and a PostgreSQL database client

hdfs_fdw →

PostgreSQL Foreign Data Wrapper for the Hadoop Distributed File System

mongo_fdw →

PostgreSQL Foreign Data Wrapper for BSON data

mysql_fdw →

PostgreSQL Foreign Data Wrapper for MySQL

pg_catcheck →

Simple tool for diagnosing system catalog corruption

pg_nosql_benchmark →

Tool for benchmarking PostgreSQL (JSONB) and MongoDB (BSON)

Postgres-XC →

Provides a write-scalable, synchronous symmetric, transparent PostgreSQL cluster

EDB’s Open Source Leadership

  • PostgreSQL Core Team
  • Bruce Momjian Vice President, Postgres Evangelist at EDB
    linkedin
  • Dave Page VP & Chief Architect, Database Infrastructure at EDB
    linkedin
  • Peter Eisentraut Consultant
    linkedin