Back to Programs

Data

PostgreSQL

The Most Advanced Open Source Relational Database

cdatabasegojavascriptpostgresqlpython
Organization website

Participation history

10 GSoC years

2026202520242023202220212020201920182017

2026

7 projects

Official year page

pgmoneta: Model Context Server implementation

The motivation behind this project is to extend and introduce a fully functional MCP server for pgmoneta. To achieve this ultimate goal, we have...

Project page

Reducing pg stat statements LWLock Contention

pg_stat_statements tracks query statistics across a PostgreSQL cluster, but its single-LWLock architecture creates a scalability bottleneck under...

Project page

B-tree Index Bloat Reduction (Page Merge)

PostgreSQL B-tree indexes often suffer from severe bloat after heavy UPDATE and DELETE workloads because the core engine currently cannot consolidate...

Project page

pgmoneta: WAL & MCP

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...

Project page

pgmoneta: Storage engines

pgmoneta’s current storage layer is fragmented, back-ends do not share full feature parity and a single backup cannot target multiple destinations at...

Project page

Historic Data for pgexporter

This project will add native historical metrics storage to pgexporter, enabling users to analyze trends and long-term performance without relying on...

Project page

pgagroal: Advanced security

This project implements true end-to-end TLS pooling for pgagroal by decoupling the cryptographic state from the physical TCP socket. By implementing...

Project page

2025

7 projects

Official year page

Enhancements to pgwatch v3 RPC integration

The existing pgwatch3_rpc_server project creates specialized RPC endpoints that allow pgwatch3 clients to export monitoring data in various formats...

CodeProject page

pgmoneta: Incremental backup for PostgreSQL 13-16

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...

CodeProject page

Extension Support for pgexporter

PostgreSQL extensions can offer detailed views of query performance, storage usage, and system health but this would need frequent manual setup to be...

CodeProject page

Upgrade pgwatch Grafana dashboards to v12

This project focused on upgrading the existing pgwatch Grafana dashboards to ensure full compatibility with the latest Grafana version 12. While some...

CodeProject page

ABI Compliance Reporting System

PostgreSQL introduced Server API and ABI Stability Guidance to help extension authors understand compatibility expectations. The policy ensures ABI...

CodeProject page

pgmoneta: WAL Filtering

pgmoneta is an open-source tool designed for PostgreSQL backup and recovery, with a strong focus on managing Write-Ahead Logging (WAL) files critical...

CodeProject page

Enhancing Pgagroal Security: Hot Reloading, Vault Improvements, and Certificate Monitoring

This project enhances Pgagroal's security by implementing hot reloading for TLS certificates and configuration files, refining the vault system for...

CodeProject page

2024

5 projects

Official year page

PostgreSQL (Pgmoneta) - WAL infrastructure

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...

CodeProject page

pgmoneta: Extended functionality

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...

CodeProject page

PostgreSQL JDBC Struct/Array Support

Currently, the composite types defined in PostgreSQL (https://www.postgresql.org/docs/current/rowtypes.html#ROWTYPES) are not exposed through the...

CodeProject page

pgagroal: Replace the I/O Layer

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...

CodeProject page

RPC Sinks for PgWatch3

This project aims to provide support for remote sinks in pgwatch3. Currently pgwatch3 allows users to write measurements to ‘sinks’. However there...

CodeProject page

2023

12 projects

Official year page

pg_adviser / index_adviser: Recommend Potentially Useful Indexes

The Index Adviser (pg_adviser) is an extension for PostgreSQL that suggests potentially useful indexes for given queries. This project aims to...

CodeProject page

PGweb Testing Harness for the official PostgreSQL Website

As part of the Google Summer of Code 2023 , we developed an automated testing harness suite for the official PostgreSQL website. The suite addresses...

CodeProject page

Develop Performance Farm Benchmarks and Website (2023)

The Performance Farm project aims to emphasize Postgresql performance as it evolves by conducting benchmarks and posting the results on a webpage....

CodeProject page

pgmoneta: Native Backup

Pgmoneta is a backup/restore solution for PostgreSQL. It can be used to backup one or multiple databases. Currently pgmoneta achieves that by calling...

Project page

Postgres Extension Tutorial / Quick Start

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...

CodeProject page

pgagroal: simple vault implemention

pgagroal is a high-performance protocol-native connection pool for PostgreSQL. It also manages authentication for users who try to access the...

Project page

Rewriting the pg_chameleon SQL library

The pg_chameleon library translates DDL from MySQL dialect to PostgreSQL dialect. In doing this, there is an intermediate tokenization step. This...

CodeProject page

pg_statviz: Time Series Analysis & Visualization of Statistics

pg_statviz is a PostgreSQL extension with a command line utility pair. The extension can snapshot cumulative and dynamic statistics of various...

CodeProject page

Improving PostgreSQL Version Support for pgexporter

Pgexporter provides Prometheus metrics for PostgreSQL servers which include some core metrics, as well as custom metrics provided by users. The...

CodeProject page

GUI representation of monitoring System Activity with the system_stats Extension in pgAdmin 4

This project involves design and developing dashboard in pgAdmin 4 which shows the system level statistics for monitoring Postgres activity with the...

CodeProject page

pgagroal: Query Cache

This project involves adding a query caching feature to pgagroal, a high-performance connection pool for PostgreSQL. The goal is to enhance...

Project page

Monitoring for pgmoneta

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...

CodeProject page

2022

7 projects

Official year page

Improve pgarchives

pgarchives is the official archive of Postgres mailing lists. Users can access the interface from the website and browse it, searching according to...

CodeProject page

Pgexporter: Custom file

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...

CodeProject page

Develop Performance Farm Benchmarks and Website

The PostgreSQL Performance Farm (short for Pgperffarm) is a project to measure and visualize the benchmark performance of each version of PostgreSQL...

CodeProject page

Improve PostgreSQL Regression Test Coverage

# 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...

CodeProject page

New and improved website for pgjdbc (JDBC)

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...

CodeProject page

pgmoneta: Storage API

pgmoneta is a backup / restore solution for PostgreSQL, it supports doing backups, listing all backups for a server, restoring a backup from a...

CodeProject page

pgmoneta: On-disk encryption

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...

CodeProject page

2021

6 projects

Official year page

Add monitoring of pg_stat_statements to pg_systat

Pg_systat is 'systat' for PostgreSQL. It allows users to monitor various PostgreSQL statistics tables from a terminal window. This project aims to...

CodeProject page

Improve pgeu-system for Conference Management

Pg-eu system is an infrastructure developed and maintained by Postgres for managing non-profit organizations along with an extensive conference...

CodeProject page

WAL-G optimization backup storage by remote-copy APIs

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...

CodeProject page

pgagroal: Metrics and monitoring

Project "Metrics and monitoring" aims to collect more effective metrics which can characterize the current status of pgagroal's pool, connections,...

CodeProject page

Develop Performance Farm Benchmarks and Website

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...

CodeProject page

Create procedural language extension for the Julia programming language

Postgresql allows developers more freedom to extend the provided capabilities in an application-specific manner compared to other popular open-source...

CodeProject page

2020

3 projects

Official year page

Develop Performance Farm Database and Website

PostgreSQL is a famous database management system, widely used by DBAs and with an open source license. There is a large community dedicated to...

CodeProject page

WAL-G performance improvements

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...

CodeProject page

Improving PL/Java build system

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...

CodeProject page

2019

4 projects

Official year page

Develop Performance Farm Database and Website

The Performance Farm is an useful way to test Postgres' functionalities while changes are being made, to analyze its efficacy on different operating...

CodeProject page

de-TOAST'ing using an iterator

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...

CodeProject page

pgAdmin 4 Query Tool Automatic Mode Detection and Enhancements

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source...

CodeProject page

ARTful Buffer Manager

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...

CodeProject page

2018

3 projects

Official year page

"Develop Performance Farm Database and Website" proposal for Google Summer of Code 2018

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...

CodeProject page

implement pg_thrift plugin for postgreSQL

One of advantages of document-oriented databases like MongoDB or Couchbase over RDBMSs is an ability to change the data scheme easily, fast and...

CodeProject page

Sorting Algorithms Benchmark and Implementation

Implement the project idea sorting algorithms benchmark and implementation (2018) Candidate sorting algorithms: Introsort Timsort Dual-pivot...

CodeProject page

2017

4 projects

Official year page

Foreign Keys for Array Elements

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...

CodeProject page

Eliminate O(N^2) scaling from rw-conflict tracking in serializable transactions

To provide strict serializable isolation among transactions, PostgreSQL needs to track read-write conflicts (rw-conflicts for short in the following...

CodeProject page

Add errors handling and parallel execution to COPY

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...

CodeProject page

Explicitly support predicate locks in index AMs besides btree

Currently, only B+-trees support page level predicate locking.For other indexes, it acquires relation level lock which can lead to unnecessary...

CodeProject page