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 MomjianVice President, Postgres Evangelist at EDB
- Dave PageVP & Chief Architect, Database Infrastructure at EDB
- PostgreSQL Contributors
- Amul SulPrincipal Software Engineer at EDB
- Ashutosh SharmaSenior Software Engineer at EDB
- Dilip KumarAssociate Database Architect at EDB
- Jeevan ChalkeSenior Software Engineer at EDB
- Jeevan LadheTechnical Architect at EDB
- Rushabh LathiaTechnical Architect at EDB
- PostgreSQL Major Contributors
- Amit LangoteSenior PostgreSQL Architect at EDB
- Devrim GündüzPrincipal Systems Engineer at EDB
- Robert HaasVP, Chief Database Scientist at EDB
- pgAdmin Project Contributors
- Akshay JoshiSenior Software Architect at EDB
- Ashesh VashiPrinciple Software Architect at EDB
- Dave PageVP & Chief Architect, Database Infrastructure at EDB