Projects per cycle
PostgreSQL, 2016 to 2026
View as table
| Projects | |
|---|---|
| 2016 | 0 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 4 |
| 2020 | 3 |
| 2021 | 6 |
| 2022 | 7 |
| 2023 | 12 |
| 2024 | 5 |
| 2025 | 7 |
| 2026 | 7 |
PROJECTS
PostgreSQL GSoC projects
58 accepted projects across 10 cycles, 2017 to 2026. Each one links to its contributor, mentors and code.
Projects listed
58
Across 10 cycles
In GSoC 2026
7
7 in 2025
Busiest cycle
2023
12 projects
Mentors named
45
Across all listed projects
First cycle
2017
Latest 2026
pgmoneta: Model Context Server implementation
Ahmed Kamal AbdElrasol
The motivation behind this project is to extend and introduce a fully functional MCP server for pgmoneta. To achieve this ultimate goal, we have...
Reducing pg stat statements LWLock Contention
hoangquan456
pg_stat_statements tracks query statistics across a PostgreSQL cluster, but its single-LWLock architecture creates a scalability bottleneck under...
B-tree Index Bloat Reduction (Page Merge)
Salma El-Sayed
PostgreSQL B-tree indexes often suffer from severe bloat after heavy UPDATE and DELETE workloads because the core engine currently cannot consolidate...
pgmoneta: WAL & MCP
Sara Nabih
pgmoneta is an open-source tool that offers a solution for PostgreSQL backup and recovery. This project is a continuation of the 2025 GSoC project on...
pgmoneta: Storage engines
Shashidhar M
pgmoneta’s current storage layer is fragmented, back-ends do not share full feature parity and a single backup cannot target multiple destinations at...
Historic Data for pgexporter
Somye
This project will add native historical metrics storage to pgexporter, enabling users to analyze trends and long-term performance without relying on...
pgagroal: Advanced security
trxvor
This project implements true end-to-end TLS pooling for pgagroal by decoupling the cryptographic state from the physical TCP socket. By implementing...
Enhancements to pgwatch v3 RPC integration
ahmad goudaMentored by Akshat Jaimini, Pavlo
The existing pgwatch3_rpc_server project creates specialized RPC endpoints that allow pgwatch3 clients to export monitoring data in various formats...
pgmoneta: Incremental backup for PostgreSQL 13-16
Ashutosh ShMentored by My-Wine-Cellar, Haoran Zhang
Implement functionality in pgmoneta and pgmoneta_ext such that an incremental backup can be taken from PostgreSQL 13 to 16. This work can build upon...
Extension Support for pgexporter
Bassam AdnanMentored by My-Wine-Cellar, resyfer
PostgreSQL extensions can offer detailed views of query performance, storage usage, and system health but this would need frequent manual setup to be...
Upgrade pgwatch Grafana dashboards to v12
Gaurav PatidarMentored by Rajiv Harlalka, Pavlo
This project focuses on upgrading the existing pgwatch dashboards to be fully compatible with Grafana version 11. With Grafana v11 removing support...
ABI Compliance Reporting System
Mankirat SinghMentored by David Wheeler, Pavlo
PostgreSQL introduced Server API and ABI Stability Guidance to help extension authors understand compatibility expectations. The policy ensures ABI...
pgmoneta: WAL Filtering
Mohab YasserMentored by My-Wine-Cellar, Shahryar
pgmoneta is an open-source tool designed for PostgreSQL backup and recovery, with a strong focus on managing Write-Ahead Logging (WAL) files critical...
Enhancing Pgagroal Security: Hot Reloading, Vault Improvements, and Certificate Monitoring
Tejas TyagiMentored by My-Wine-Cellar, Luca Ferrari
This project enhances Pgagroal's security by implementing hot reloading for TLS certificates and configuration files, refining the vault system for...
PostgreSQL (Pgmoneta) - WAL infrastructure
ShahryarMentored by My-Wine-Cellar, Haoran Zhang
In this project, we want to implement an infrastructure in Pgmoneta that can read and parse the WAL files into WAL records. When our infrastructure...
pgmoneta: Extended functionality
ChaoMentored by My-Wine-Cellar, Haoran Zhang
The project aims to provide a new code base, pgmoneta_ext, to enable pgmoneta to access files on the PostgreSQL server side, including the ability to...
PostgreSQL JDBC Struct/Array Support
Arjan MarkuMentored by Dave Cramer, Mark Wong
Currently, the composite types defined in PostgreSQL (https://www.postgresql.org/docs/current/rowtypes.html#ROWTYPES) are not exposed through the...
pgagroal: Replace the I/O Layer
decarvMentored by My-Wine-Cellar, Luca Ferrari
The project consists of replacing the I/O Layer of pgagroal, today highly dependent on the libev library, for a pgagroal's own implementation. The so...
RPC Sinks for PgWatch3
Akshat JaiminiMentored by Mark Wong, Pavlo
This project aims to provide support for remote sinks in pgwatch3. Currently pgwatch3 allows users to write measurements to ‘sinks’. However there...
pgmoneta: Native Backup
Haoran ZhangMentored by Jesper Pedersen, Mariam Fahmy Sobhy
Pgmoneta is a backup/restore solution for PostgreSQL. It can be used to backup one or multiple databases. Currently pgmoneta achieves that by calling...
Postgres Extension Tutorial / Quick Start
Ishaan AdarshMentored by David Wheeler, Jimmy Angelakos
This project aims to create a comprehensive and easy-to-follow tutorial on how to write a Postgres extension, addressing the current lack of clear...
PGweb Testing Harness for the official PostgreSQL Website
Akshat JaiminiMentored by Ilaria Battiston, sfrost
As part of the Google Summer of Code 2023 , we developed an automated testing harness suite for the official PostgreSQL website. The suite addresses...
pgagroal: Query Cache
Sudeep ReddyMentored by Jesper Pedersen, Nikita Bugrovsky
This project involves adding a query caching feature to pgagroal, a high-performance connection pool for PostgreSQL. The goal is to enhance...
pgagroal: simple vault implemention
JichenMentored by Jesper Pedersen, Athila Mattos, Dustin Kut Moy Cheung
pgagroal is a high-performance protocol-native connection pool for PostgreSQL. It also manages authentication for users who try to access the...
Develop Performance Farm Benchmarks and Website (2023)
Anil rundlaMentored by Ilaria Battiston, sfrost
The Performance Farm project aims to emphasize Postgresql performance as it evolves by conducting benchmarks and posting the results on a webpage....
Monitoring for pgmoneta
Zhengshun LinMentored by Jesper Pedersen
In this project, we will expand metrics to help users observe the running status of pgmoneta and each server at any time. Additionally, a large...
Improving PostgreSQL Version Support for pgexporter
resyferMentored by Jesper Pedersen, Athila Mattos, Nikita Bugrovsky
Pgexporter provides Prometheus metrics for PostgreSQL servers which include some core metrics, as well as custom metrics provided by users. The...
pg_statviz: Time Series Analysis & Visualization of Statistics
Rajiv HarlalkaMentored by Jimmy Angelakos, Pavlo, Boriss Mejías
pg_statviz is a PostgreSQL extension with a command line utility pair. The extension can snapshot cumulative and dynamic statistics of various...
GUI representation of monitoring System Activity with the system_stats Extension in pgAdmin 4
Sahil HarpalMentored by Khushboo, Aditya Toshniwal
This project involves design and developing dashboard in pgAdmin 4 which shows the system level statistics for monitoring Postgres activity with the...
Rewriting the pg_chameleon SQL library
Kaustubh MMentored by Andreas 'ads' Scherbaum, Federico Campoli
The pg_chameleon library translates DDL from MySQL dialect to PostgreSQL dialect. In doing this, there is an intermediate tokenization step. This...
pg_adviser / index_adviser: Recommend Potentially Useful Indexes
Ahmed Ibrahim HashimMentored by sfrost, Gurjeet S.
The Index Adviser (pg_adviser) is an extension for PostgreSQL that suggests potentially useful indexes for given queries. This project aims to...
Improve pgarchives
Sahil HarpalMentored by Ilaria Battiston, Andreas 'ads' Scherbaum
pgarchives is the official archive of Postgres mailing lists. Users can access the interface from the website and browse it, searching according to...
Pgexporter: Custom file
Donglin XieMentored by Jesper Pedersen, Athila Mattos, Nikita Bugrovsky
Pgexporter is a Prometheus exporter for PostgreSQL. In this project, we add the option to have a custom query file to specify the queries run against...
Develop Performance Farm Benchmarks and Website
Yedil SerzhanMentored by Ilaria Battiston, Andreas 'ads' Scherbaum
The PostgreSQL Performance Farm (short for Pgperffarm) is a project to measure and visualize the benchmark performance of each version of PostgreSQL...
Improve PostgreSQL Regression Test Coverage
DongWook LeeMentored by sfrost, Reid
# proposal summary PostgreSQL is a very actively developed project and there are so many existing codes and so many new ones are added. I think there...
New and improved website for pgjdbc (JDBC)
Utkarsh ShuklaMentored by Dave Cramer, Andreas 'ads' Scherbaum
This project would aim to update the pgjdbc website. Currently, it is based on a very old PostgreSQL template and uses Jekyll to build it & also this...
pgmoneta: Storage API
Mariam FahmyMentored by Jesper Pedersen, Athila Mattos, Nikita Bugrovsky
pgmoneta is a backup / restore solution for PostgreSQL, it supports doing backups, listing all backups for a server, restoring a backup from a...
pgmoneta: On-disk encryption
JichenMentored by Andrea Vibelli, Dustin Kut Moy Cheung
This project aims to add support for on-disk encryption of backups. These are some tasks that need to be completed: Create an internal API for...
Add monitoring of pg_stat_statements to pg_systat
Jianhui LuMentored by Mark Wong, gorthx, Andreas 'ads' Scherbaum
Pg_systat is 'systat' for PostgreSQL. It allows users to monitor various PostgreSQL statistics tables from a terminal window. This project aims to...
Improve pgeu-system for Conference Management
Saurav ShrivastavMentored by Andreas 'ads' Scherbaum, Stephen Frost, Ila
Pg-eu system is an infrastructure developed and maintained by Postgres for managing non-profit organizations along with an extensive conference...
WAL-G optimization backup storage by remote-copy APIs
Alexander SlesarevMentored by Andrey Borodin, Daniil Zakhlystov
WAL-G supports two backup types: delta(incremental) and full. Delta backup has higher performance on pushing phase, but it is slower on fetch and...
pgagroal: Metrics and monitoring
Junduo DongMentored by Andrey Borodin, Jesper Pedersen, Lætitia Avrot
Project "Metrics and monitoring" aims to collect more effective metrics which can characterize the current status of pgagroal's pool, connections,...
Develop Performance Farm Benchmarks and Website
YoungHwan JooMentored by Andreas 'ads' Scherbaum, Stephen Frost, Ila
PostgreSQL is a big and active open-source DBMS. This means that the code changes frequently and there are a lot of branches and commits. When big...
Create procedural language extension for the Julia programming language
Konstantina SkovolaMentored by Mark Wong, Fabrízio Mello
Postgresql allows developers more freedom to extend the provided capabilities in an application-specific manner compared to other popular open-source...
Develop Performance Farm Database and Website
Ilaria BattistonMentored by Andreas Scherbaum, Stephen Frost
PostgreSQL is a famous database management system, widely used by DBAs and with an open source license. There is a large community dedicated to...
WAL-G performance improvements
Daniil ZakhlystovMentored by Andrey Borodin, Georgy Rylov
The goal of the project is to make two enhancements of archival and restoration tool WAL-G. The first one is to improve the performance of the backup...
Improving PL/Java build system
mrrobotMentored by Andrey Borodin, Chapman Flack
PL/Java is an open source extension PostgreSQL that allows stored procedures, triggers and functions to be written in Java. PL/Java ‘s build system...
Develop Performance Farm Database and Website
Ilaria BattistonMentored by Mark Wong, Andreas Scherbaum
The Performance Farm is an useful way to test Postgres' functionalities while changes are being made, to analyze its efficacy on different operating...
de-TOAST'ing using an iterator
Binguo BaoMentored by Andrey Borodin, Stephen Frost, Atri Sharma +1
This project would aim to provide the ability to de-TOAST a fully TOAST'd and compressed field using an iterator, and then update the appropriate...
pgAdmin 4 Query Tool Automatic Mode Detection and Enhancements
Yosry AhmedMentored by Dave Page
pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source...
ARTful Buffer Manager
mvpantMentored by Andrey Borodin, Stephen Frost
The main goal of this project is to implement and evaluate an adaptive radix tree as an alternative to the current underlying data structure of...
"Develop Performance Farm Database and Website" proposal for Google Summer of Code 2018
Hongyuan MaMentored by Mark Wong, Stephen Frost
I plan to implement the PerfFarm project using a separate front-end and back-end development approach and use PostgreSQL as a database for storing...
implement pg_thrift plugin for postgreSQL
Yan CuiMentored by Andrey Borodin, Anastasia Lubennikova, Aleksander Alekseev
One of advantages of document-oriented databases like MongoDB or Couchbase over RDBMSs is an ability to change the data scheme easily, fast and...
Sorting Algorithms Benchmark and Implementation
Kefan YangMentored by Andrey Borodin, Atri Sharma
Implement the project idea sorting algorithms benchmark and implementation (2018) Candidate sorting algorithms: Introsort Timsort Dual-pivot...
Eliminate O(N^2) scaling from rw-conflict tracking in serializable transactions
Mengxing LiuMentored by alvherre, Kevin Grittner
To provide strict serializable isolation among transactions, PostgreSQL needs to track read-write conflicts (rw-conflicts for short in the following...
Foreign Keys for Array Elements
Mark RofailMentored by Alexander Korotkov, Stephen Frost, alvherre
My proposal is to target the performance issue regarding the foreign keys for the array index. Any UPDATE or DELETE statement on a Primary Key table...
Add errors handling and parallel execution to COPY
Alexey KondratovMentored by Anastasia Lubennikova, Alexander Korotkov, alvherre
Using PostgreSQL (PG) on the daily basis for years I found that there are some use-cases when you need to load (e.g. for a further analytics) a bunch...
Explicitly support predicate locks in index AMs besides btree
Shubham BaraiMentored by Andrey Borodin, Kevin Grittner
Currently, only B+-trees support page level predicate locking.For other indexes, it acquires relation level lock which can lead to unnecessary...
Data: Google Summer of Code public archive. Official GSoC archive