Hacking on Postgres: An Overview

on YouTube ↗50m

" summary

Step‑by‑step roadmap for getting code into Postgres: use the mailing list & commitfests workflow, attach discussion threads in the CF app, and expect long asynchronous reviews; examine src/{backend,bin,test}, contrib, and docs to find readmes and call trees; use palloc/pfree and memory contexts and prefer built allocators (slab/generation) over malloc; follow style (tabs, 80 cols, brace placement); iterate locally with vim+tmux scripts, rebuild, run make check or tap tests, and debug crashes with gdb/ldb — demo shows an incremental‑sort patch that triggers a use‑after‑free and is found with the debugger.

AI-written summary · about

" chapters (7)

1. 0:00Introduction and context
2. 3:40Community and patch process
3. 13:52Contributor workflow
4. 16:58Navigating the source code
5. 24:00Internal facilities
6. 37:00Development and debugging
7. 47:51Testing and submission

" related talks

• 47mBeginner's guide to PostgreSQL HackingPavan Deolasee · PGConf India 2025
• 50mPostgreSQL hacker tipsMichael Paquier · PostgreSQL Conference Europe 2023
• 27mHow Do We Get Postgres to the Next Level?Jimmy Angelakos · PGDay Lowlands 2025
• 27mOpen Source Contributions to Postgres: The BasicsElizabeth Garrett Christensen · POSETTE: An Event for Postgres 2024
• 21mDiscovering Postgres...Emma Saroyan · PostgreSQL Conference Europe 2024
• 47mMy Journey in PostgreSQL bug fixingBertrand Drouvot · PostgreSQL Conference Europe 2024
• 33mElephant in a nutshell - Navigating the Postgres community 101Valeria Kaplan · PostgreSQL Conference Europe 2023
• 42mMy Journey in PostgreSQL bug fixingBertrand Drouvot · PGConf.dev 2025