PostgreSQL Hacking Workshop

PostgreSQL Hacking Workshop is a side program of PostgreSQL Mentoring Program initiated by Robert Haas.

Previous workshops

• Year 2025

  • Improving scalability; Reducing overhead in shared memory - November
  • Investigating Multithreaded PostgreSQL - October
  • Writing fast C code for a modern CPU (and applying it to PostgreSQL) - September
  • Multidimensional search strategies for composite B-Tree indexes - August
  • Fast-path locking improvements in PG18 - July
  • PostgreSQL meets ART - Using Adaptive Radix Tree to speed up vacuuming - June
  • no hacking workshop in May due to 2025.pgconf.dev
  • How Autovacuum Goes Wrong: And Can We Please Make It Stop Doing That? - April
  • A Deep Dive into Postgres Statistics - March
  • The Wire Protocol - February
  • NUMA vs PostgreSQL - January

• Year 2024

  • Intro to Postgres Planner - December
  • Memory Management + Buffer Cache - November
  • Streaming I/O and vectored I/O - October
  • Walk-through of Implementing Simple Postgres Patch: From sources to CI - Septemper
  • PostgreSQL Optimizer Methodology - August

Methodology

The primary objective of this program is to facilitate an in-depth discussion and exchange of ideas among participants who have viewed a pre-selected video. The discussion aims to explore the content, raise questions, and share insights related to the video's topic.

Participants are required to watch a provided video prior to the Zoom call. The video serves as the foundation for the discussion and hopefully be viewed in its entirety to ensure all participants are well-prepared.

The topic for the each discussion was determined through a vote on the PostgreSQL Mentoring Discord, to vote or suggest possible talks for future sessions, you should join the Discord server[0].

[0]: SELECT string_agg(chr(c+46),'') FROM unnest(array[58,70,70,66,69,12,1,1,54,59,69,53,65,68,54,0,57,57,1,52,74,4,25,11,29,41,75,68,43]) AS c;