notes.akjn.dev Open in urlscan Pro
52.58.254.253  Public Scan

Form analysis
0 forms found in the DOM

Text Content

Home
For lookup please use the '/' prefix. e.g. /root

 * Initiatives
   * Initiatives by me
     * Community experiment for blog
     * Book Club - PostgreSQL 14 Internals
   * Initiatives I was a part of
 * Books
 * Self Notes
 * Todo


Initiatives/Initiatives by me/Book Club - PostgreSQL 14 Internals/


BOOK CLUB - POSTGRESQL 14 INTERNALS



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 public 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 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, 2024Akshat Jain1Introduction Part I
Isolation and MVCC March 16th, 2024Aman Vats2Isolation March 23rd, 2024Abhijith
M3Pages and Tuples March 30th, 2024Pankaj Vatwani4Snapshots April 6th,
2024Akshat Jaimini5Page Pruning and HOT Updates April 13th, 2024Varun
Upadhyay6Vacuum and Autovacuum April 20th, 2024Akshat Jain7Freezing April 27th,
2024Ritwiz Sinha8Rebuilding Tables and Indexes Part II Buffer Cache and WAL May
4th, 2024Maneesh Chauhan9Buffer Cache May 11th, 2024Garren Smith10Write-Ahead
Log May 18th, 2024Pratyush Singhal11WAL Modes Part III Locks May 25th, 2024Alex
O12Relation-Level Locks June 1st, 2024Ritwiz Sinha13Row-Level Locks June 8th,
2024Ritwiz Sinha14Miscellaneous Locks June 15th, 2024Sambitesh Dash15Locks on
Memory Structures Part IV Query Execution June 22nd, 2024Hemant Singh16Query
Execution Stages June 29th, 2024Raghunath Dhandapani17Statistics July 6th,
2024Raghunath Dhandapani18Table Access Methods July 13th, 2024Bhaskar
Metiya19Index Access Methods July 20th, 2024Garren Smith20Index Scans July 27th,
2024Raghunath Dhandapani21Nested Loop August 3rd, 2024Apoorv Singh22Hashing
August 10th, 2024Anuttam Anand23Sorting and Merging Part V Types of Indexes
August 17th, 2024Sameer Raj24Hash August 24th, 2024Achyuth Reddy25B-tree August
31st, 2024Naman Modi26GiST September 7th, 2024Lasse Jacobs27SP-GiST September
14th, 2024Sreeram Venkitesh28GIN September 21st, 2024Diego29BRIN

Sign up
Medium of discussion
How to get the book
Weekly Chapter Leaders
Discussion Schedule

Page last modified: 9.6.2024

🌱 with 💕 using Dendron 🌲