PostgreSQL 学习资料，包括但不限于文章、书籍、教程、视频。

Links for developers

• So, you want to be a developer? by Selena Deckelmann
• PostgreSQL Developer FAQ
• PostgreSQL Outstanding Features
• PostgreSQL Backend Flowchart
• Introduction to Hacking PostgreSQL
• A Tour of PostgreSQL Internals by Tom Lane, 2000
• Pgsrcstructure by 石井達夫, 2005
• SQL-92
• SQL-99 Complete, Really
• Submitting a Patch
• Reviewing a Patch
• Review of Patch Reviewing by Stephen Frost, PGCon 2011
• Hacking the Query Planner by Tom Lane, PGCon 2011 📹
• PGXN PostgreSQL Extension Network
• HOT Understanding this important update optimization
• Packaging Related Objects into an Extension
• Background Worker Processes
• Deal with Corruption
• Slow Query Questions
• Using EXPLAIN
• Understanding EXPLAIN
• Foreign data wrappers
• Lock Monitoring
• Extending PostgreSQL in C
• Implementing your first PostgreSQL extension: From Coding to Distribution
• Plugable Table Storage in PostgreSQL by Andres Anarazel, 2019
• PostgreSQL GDB commands gdb 打印 plantree
• Unofficial documentation for PostgreSQL hooks
• Incremental backup
• Pgsrcstructure
• Profiling with perf

Blogs

• Planet
• momjian.us
• depesz.com by Hubert Lubaczewski
• Robert Haas’s blogspot
• Michael Paquier’s blog
• PostgreSQL and Databases in general Amit Kapila’s blogspot
• What PostgreSQL has over other open source SQL databases: Part I
• What PostgreSQL has over other open source SQL databases: Part II
• Why use Postgres by Craig Kerstiens
• Indexes in PostgreSQL by Egor Rogov
  • 1 Introduction
  • 2 Interface
  • 3 Hash
  • 4 Btree
  • 5 GiST
  • 6 SP-GiST
  • 7 GIN
  • 8 RUM
  • 9 BRIN
  • 10 Bloom
• MVCC in PostgreSQL by Egor Rogov
  • 1. Isolation
  • 2. Forks, files, pages
  • 3. Row Versions
  • 4. Snapshots
  • 5. In-page vacuum and HOT updates
  • 6. Vacuum
  • 7. Autovacuum
  • 8. Freezing
• Queries in PostgreSQL by Egor Rogov, 2022
  • 1. Query execution stages
  • 2. Statistics
  • 3. Sequential scan
  • 4. Index scan
  • 5. Nested loop
  • 6. Hashing
  • 7. Sort and merge
• Tuple internals: exposing, exploring and explaining by Nikolay Shaplov, 2016
• Understanding of Bloat and VACUUM in PostgreSQL by Avinash Vallarapu, 2018
• Tuning Autovacuum in PostgreSQL and Autovacuum Internals by Avinash Vallarapu, 2018
• Tuning PostgreSQL Database Parameters to Optimize Performance by Ibrar Ahmed, 2018
• Tune Linux Kernel Parameters For PostgreSQL Optimization by Ibrar Ahmed, 2018
• MVCC and VACUUM by Robert Haas, 2017
• VACUUM FULL doesn’t mean “VACUUM, but better” by Robert Haas, 2014
• DO or UNDO - there is no VACUUM by Robert Haas, 2018
• Different Approaches for MVCC used in well known Databases by Amit Kapila, 2015
• Why Uber Engineering Switched from Postgres to MySQL 2016
• On Uber’s Choice of Databases by Markus Winand, 2016
• Creating a Postgres Foreign Data Wrapper by Aaron Son, 2022
• PostgreSQL vs. MySQL: A 360-degree Comparison by EDB Team, 2019
• Understanding Prepared Transactions and Handling the Orphans by Hamid Akhtar, 2020
• OIDs demoted to normal columns: a glance at the past by Daniel Verite, 2019
• How Postgres Makes Transactions Atomic
• How to Manage Connections Efficiently in Postgres, or Any Database
• Measuring the Memory Overhead of a Postgres Connection by Andres Freund, Oct 2020
• Analyzing the Limits of Connection Scalability in Postgres
• Improving Postgres Connection Scalability: Snapshots
• THOUGHTS ON POSTGRESQL IN 2024 by JONATHAN KATZ

Locking related

• PostgreSQL locking, Part 1: Row Locks
• PostgreSQL locking, part 2: heavyweight locks
• PostgreSQL locking, part 3: lightweight locks
• PostgreSQL rocks, except when it blocks: Understanding locks
• When Postgres blocks: 7 tips for dealing with locks
• Postgres Locking Revealed

Books

• PostgreSQL: Introduction and Concepts by Bruce Momjian, 2001, 介绍 PG 基本用法及一些概念
• PostgreSQL: Up and Running, 3rd Edition by Regina O. Obe, Leo S. Hsu (Nov, 2017), 介绍 PG 基本使用方法
• Mastering PostgreSQL 11 Expert techniques to build scalable, reliable, and fault-tolerant database applications by Hans-Jurgen Schonig, 2018
• Mastering PostgreSQL 12 Advanced techniques to build and administer scalable and reliable PostgreSQL database by Hans-Jürgen Schönig, 2019
• Mastering PostgreSQL 13 Build, administer, and maintain database applications efficiently with PostgreSQL 13 by Hans-Jürgen Schönig, 2020
• The Internals of PostgreSQL by Hironobu SUZUKI
  • Chapter 1. Database Cluster, Databases and Tables
  • Chapter 2. Process and Memory Architecture
  • Chapter 3. Query Processing
  • Chapter 4. Foreign Data Wrappers (FDW)
  • Chapter 5. Concurrency Control
  • Chapter 6. VACUUM Processing
  • Chapter 7. Heap Only Tuple (HOT) and Index-Only Scans
  • Chapter 8. Buffer Manager
  • Chapter 9. Write Ahead Logging (WAL)
  • Chapter 10. Base Backup and Point-In-Time Recovery (PITR)
  • Chapter 11. Streaming Replication
• Mastering PostGIS by Dominik Mikiewicz, 2017

Papers

• Enhancement of the ANSI SQL Implementation of PostgreSQL by Stefan Simkovics

Transaction

• Serializable Snapshot Isolation (SSI) in PostgreSQL
• Information about the SSI implementation for the SERIALIZABLE transaction isolation level in PostgreSQL

Tutorials

• 2-Day Introduction to PostgreSQL 11
• Introduction to PostGIS
• Kartones/postgres-cheatsheet.md

Videos

• PostgreSQL Internals Through Pictures by Bruce Momjian, 2015
• Inside PostgreSQL Shared Memory by Bruce Momjian, 2015
• How does PostgreSQL actully work by Peter Eisentraut, 2016
• PostgreSQL Top Ten Features by Simon Riggs, 2014
• Understanding Autovacuum by Dan Robinson, 2016
• Hacking on PostgreSQL by Stephen Frost, 2013
• Debugging your PL/pgSQL code by Jim Mlodgenski, 2016
• Zen of Postgres: How to be a happy hacker by Andrew Dunstan, 2012
• MVCC Unmasked by Bruce Momjian, OSCon 2011
• Understanding Advanced Datatypes in PostgreSQL 2016
• Advanced Data Types In PostgreSQL by Andreas Scherbaum, 2019
• Unlocking the Postgres Lock Manager / Slides by Bruce Momjian, 2012
• Index Internals by Heikki Linnakangas, 2016
• PostgreSQL Partitioning by Robert Treat, PGCon 2018
• PostgreSQL Partitioning by Simon Riggs, PostgresOpen 2019
• Hacking PostgreSQL / Slides by Stephen Frost, FOSDEM 2019
• Webinar: PostgreSQL Partitioning by Simon Riggs, 2020
• Learning to Hack on Postgres Planner by Melanie Plageman, PGCon 2019
• An introduction to Memory Contexts by Chris Travers, PGCon 2019
• Hacking the Query Planner, Again by Richard Guo, PGCon 2020
• Asynchronous IO for PostgreSQL by Andres Freund, PGCon 2020
• PostgreSQL 空闲空间管理 by Wang Xiaoran, PGConf.Asia 2021
• Why Uber Engineering Switched from Postgres to MySQL by Hussein Nasser, 2020
• A PostgreSQL Response to Uber slides by Christophe Pettus, 2017
• EXPLAIN Explained by Josh Berkus, 2016
• PGX: Build Postgres Extensions with Rust by Eric Ridge, 2021
• PostgreSQL Extensions: A Deeper Dive by Jignesh Shah, 2019
• Fascinating Reporting With Postgres psql by Christopher L. Augustus, 2019
• Intro To Foreign Data Wrappers In Postgres by Sam Bail, 2019
• Mistaken And Ignored Parameters While Optimizing A PostgreSQL Database by Avinash Vallarapu, 2019
• JSONB Tricks by Colton Shepard, 2019
• Identifying Slow Queries and Fixing Them! by Stephen Frost, Postgres Open 2016
• Look It Up Practical PostgreSQL Indexing by Christphe Pettus, PostgresOpen 2019
• BDR - A Multi-Master PostgreSQL Solution by Mark Wong, 2020
• Geographically distributed multi-master replication with PostgreSQL and BDR by Craig Ringer, 2018
• Logical Replication in PostgreSQL by Kuntal Ghosh, 2019
• A Review of PostgreSQL Replication Approaches by Boriss Mejias, 2021
• Database Dumps and Backups by Karen Jex, 2021
• Sharding and Scaling PostgreSQL: Principles and Practice by Jason Petersen, 2015
• How to Scale Postgres: Automation, Tuning & Sharding by Kukas Fittle, Postgres Vision 2020
• Citus: Distributed PostgreSQL as an Extension by Marco Slot, 2021
• PostgreSQL Optimizer Methodology by Robert Haas, CMU Database Group - Vaccination Database Tech Talks (2021)
• Explaining the Postgres Query Optimizer by Bruce Momjian, 2023
• IPC in PostgreSQL by Thomas Munro, PGCon 2023
• Writing a Foreign Data Wrapper by Christophe Pettus, PGCon 2023
• Logical Replication of DDLs by Peter Smith & Zheng Li (Zane), PGCon 2023
• PostgreSQL 16 and beyond by Amit Kapila, PGCon 2023
• BRIN improvements and new opclasses by Tomas Vondra, PGCon 2023
• Sorting Out glibc Collation Challenges by Joe Conway, PGCon 2023
• IO in PostgreSQL: Past, Present, Future by Andres Freund, 2022
• Understanding and Fixing Autovacuum by Robert Haas, PGConf India 2023
• How to use the Postgres query planner to debug bad plans and speed up queries by Lukas Fittl, 2023
• Deeper Understanding of PostgreSQL Execution Plan by Jobin Augustine, PGConf India 2020
• Toward full ACID distributed transaction support with FDW by Nikhil, PGConf India 2020

Greenplum specific

• Greenplum Database Tutorial for Beginners
• Greenplum性能优化之路 –（一）分区表
• Greenplum性能优化之路 –（二）存储格式
• Greenplum性能优化之路 –（三）ANALYZE
• Greenplum 分布式数据库内核揭秘(上篇)
• Greenplum 分布式数据库内核揭秘(下篇)
• Greenplum Storage Considerations
• 新一代数据分析及实时数仓平台 Greenplum 介绍
• Greenplum —— 一个用于分析、机器学习和AI的开源大规模并行数据库平台
• Brin Index 在 Append Only Table 中的实现
• Brin Index 在 Greenplum 7 中的理论与实践
• 当谈起 Greenplum 7 时，我们在谈什么？
• Greenplum 中的多阶段聚集实现
• Greenplum 的分布式锁及其相关的一切
• 《深入浅出 Greenplum 内核》系列视频 课程合集主页
  • 新一代大数据分析平台 Greenplum 架构解读
  • 开源分布式数据库 Greenplum 并行执行引擎揭秘
  • 开源大数据分析平台 Greenplum 查询优化揭秘
  • Greenplum 内核揭秘之B树索引
  • Greenplum 内核揭秘之 MVCC 并发控制
  • Greenplum 内核揭秘之排序算法
  • Greenplum 分布式事务和两阶段提交协议
  • 揭秘 Greenplum 存储引擎之Heap表
  • Greenplum 高可用理论与实践
  • 揭秘 Greenplum 恢复（Recovery）系统
• Parallel Postgres: What’s Coming in Greenplum 7
• Greenplum 分布式数据库内核揭秘
• Greenplum 中的资源管理策略
• Introduction To Greenplum Architecture by MAX YANG
• Greenplum Resource Groups by Keaton Adams, 2019
• A Practical Guide to Greenplum Database Resource Group Management by Wen Wang, 2022
• Append Optimized (AO) Table Design by Ashwin Agrawal, 2022

YugaByteDB specific

• Distributed SQL Databases Deconstructed by Karthik Ranganathan, 2019
• Extending PostgreSQL to Google Spanner architecture by Karthik Ranganathan, 2020
• YugabyteDB: Bringing Together the Best of Amazon Aurora and Google Spanner by Karthik Ranganathan, 2020
• Distributed Transactions in YugabyteDB by Karthik Ranganathan, 2021

Neon: Serverless Postgres

• SELECT ’Hello, World’ by Nikita Shamgunov, 2022
• Architecture decisions in Neon by Heikki Linnakangas, 2022
• Neon: Serverless PostgreSQL! Presentation on storage system by Heikki Linnakangas in the CMU Database Group seminar series

Postgres-XL

• Scale-out PostgreSQL with Postgres-XL by Mason Sharp, 2015

HA related

• Full Automatic Database: PostgreSQL HA with Kubernetes by Josh Berkus, KubeCon EU 2016
• Elephants on Automatic: HA Clustered PostgreSQL with Helm by Josh Berkus & Oleksii Kliukin, 2017
• Why does Neon use Paxos instead of Raft, and what’s the difference? by Stas Kelvich, 2022

References:
[1] Awesome Postgres
[2] PostgreSQL Related Slides and Presentations