awesome-postgres-hacking
github.com/pghacking/awesome-postgres-hacking ↗A curated list of awesome PostgreSQL hacking resources.
Use this list with your AI agent
Add the Context Awesome MCP server to Claude, Cursor, or any MCP client, then ask:
"Show me architecture & overview resources from awesome-postgres-hacking"
Installation instructions →What's inside
Core Internals
- A Comprehensive Overview of PostgreSQL Query Processing StagesArchitecture & Overview
Cary Huang
- A Tour of PostgreSQL InternalsArchitecture & Overview
Tom Lane, 2000
- CMU Database Group, PostgreSQL Optimizer MethodologyPlanner
Robert Haas
- flex & bisonParser
- Inside the PostgreSQL Query OptimizerPlanner
Neil Conway, 2005
- Lexical Analysis With Flex, for Flex 2.6.3Parser
Development
- Citus Con 2022, Analyzing Postgres performance problems using perf and eBPFPerformance & Observability
Andres Freund -
- .devcontainerTools
Junwang Zhao - Unofficial devcontainer config for Postgres.
- Dynamic TracingPerformance & Observability
- PgCon 2019, Let's Dtrace PostgresPerformance & Observability
Adam Wolk -
- PGConf.dev 2024, Analyzing cacheline contention using perf c2cPerformance & Observability
Andres Freund -
- PGConf.dev 2025, Advanced testing with Injection PointsTools
Michael Paquier -
Learning Resources
- DeepWiki postgres
DeepWiki generated up-to-date postgres documentation.
- PostgreSQL 14 Internals
Egor Rogov - This book is for those who will not settle for a black-box approach when working with a database.
- PostgreSQL Hacking Workshop
- The Internals of PostgreSQL
Hironobu SUZUKI - The main purposes of this document are to explain how each subsystem works, and to provide the whole picture of PostgreSQL.
Community & Contributing
- Developer FAQContributing
- HackorumMailing Lists
A web-based archive and frontend for the PostgreSQL hackers mailing list.
- People, Postgres, DataCommunity
- PGCon 2019, A journey from PostgreSQL enthusiast to committerContributing
Amit Kapila -
- PGConf.EU 2023, Making your patch more committableContributing
Melanie Plageman
- PGConf.EU 2023, PostgreSQL Hacker TipsContributing
Michael Paquier
Extension Hacking
- Hooks in PostgreSQL
Guillaume Lelarge
- PGCon 2023, Writing a Foreign Data Wrapper
Christophe Pettus
- pgrx
Build Postgres Extensions with Rust!
- Unofficial documentation for PostgreSQL hooks
Tamika Nomara
Showing a sample of 60 resources. View the full list on GitHub →