PostgreSQL 14 Internals
Update: September 22nd, 2024
The book club is now over. If you'd like to get access to the weekly discussion emails, feel free to fill out the Google form. I'll check it periodically and send out Google Group invites. You would have access to all the past discussion emails on Google Groups.
We are going to cover PostgreSQL 14 Internals book by Egor Rogov.
We will read one chapter a week and discuss over a Google Group. Your email will be visible to other group members if you post, but otherwise it will not be visible to anyone.
Sign up
If you'd like to join the group, please fill this Google form, or reach out to me on Twitter.
Please spread the word to anyone who might be interested! :)
Also, you don't need to be an expert to join along. We are all in it to learn together as a community!
Medium of discussion
All discussions will be done over text emails. We don't plan on having any Zoom or Google Meet calls. This allows people to read at their own pace asynchronously, and still be able to participate in the discussion.
How to get the book
The PDF version of the book is available for free here. You can also order a printed copy from here.
Weekly Chapter Leaders
We will have one person lead the discussion each week. They will send out an email by Saturday/Sunday of that respective week recapping the chapter and sharing their thoughts. It doesn't have to be exhaustive, could even be a couple of paragraphs - the main intent is to get the discussion going and give others a starting point to chime in.
I'd love to see people interested in volunteering to lead a chapter. But if there aren't any leaders for a week, I'll take up this responsibility and get the discussion going.
To the leaders: You don't have to worry about being an expert, or about what to say. It's a community discussion, and we're all in it to learn from each other! :)
Discussion Schedule
| Date | Leader | Chapter | Title |
| March 9th, 2024 | Akshat Jain | 1 | Introduction |
| Part I Isolation and MVCC | |||
|---|---|---|---|
| March 16th, 2024 | Aman Vats | 2 | Isolation |
| March 23rd, 2024 | Abhijith M | 3 | Pages and Tuples |
| March 30th, 2024 | Pankaj Vatwani | 4 | Snapshots |
| April 6th, 2024 | Akshat Jaimini | 5 | Page Pruning and HOT Updates |
| April 13th, 2024 | Varun Upadhyay | 6 | Vacuum and Autovacuum |
| April 20th, 2024 | Akshat Jain | 7 | Freezing |
| April 27th, 2024 | Ritwiz Sinha | 8 | Rebuilding Tables and Indexes |
| Part II Buffer Cache and WAL | |||
| May 4th, 2024 | Maneesh Chauhan | 9 | Buffer Cache |
| May 11th, 2024 | Garren Smith | 10 | Write-Ahead Log |
| May 18th, 2024 | Pratyush Singhal | 11 | WAL Modes |
| Part III Locks | |||
| May 25th, 2024 | Alex O | 12 | Relation-Level Locks |
| June 1st, 2024 | Ritwiz Sinha | 13 | Row-Level Locks |
| June 8th, 2024 | Ritwiz Sinha | 14 | Miscellaneous Locks |
| June 15th, 2024 | Sambitesh Dash | 15 | Locks on Memory Structures |
| Part IV Query Execution | |||
| June 22nd, 2024 | Hemant Singh | 16 | Query Execution Stages |
| June 29th, 2024 | Raghunath Dhandapani | 17 | Statistics |
| July 6th, 2024 | Raghunath Dhandapani | 18 | Table Access Methods |
| July 13th, 2024 | Bhaskar Metiya | 19 | Index Access Methods |
| July 20th, 2024 | Vaibhav Kurhe | 20 | Index Scans |
| July 27th, 2024 | Lasse Jacobs | 21 | Nested Loop |
| August 3rd, 2024 | Apoorv Singh | 22 | Hashing |
| August 10th, 2024 | Raghunath Dhandapani | 23 | Sorting and Merging |
| Part V Types of Indexes | |||
| August 17th, 2024 | Sameer Raj | 24 | Hash |
| August 24th, 2024 | Achyuth Reddy | 25 | B-tree |
| August 31st, 2024 | Naman Modi | 26 | GiST |
| September 7th, 2024 | Lasse Jacobs | 27 | SP-GiST |
| September 14th, 2024 | Sambitesh Dash | 28 | GIN |
| September 21st, 2024 | Diego | 29 | BRIN |
Backlinks