News for hackers. Stuff that matters.
Re:The Internals of PostgreSQL by grantjpowell on Wednesday January 26, 2022 @02:00PM (#30090102)
I constantly recommend this at work. The specific content isn't super helpful to Saas day to day development, but for me it built an intuition about postgres that has been invaluable. I think once I understood the "heart and soul" of postgres, the heap and the mvcc, many other properties about the database just "clicked" in my head.
Re:The Internals of PostgreSQL by rattray on Wednesday January 26, 2022 @02:03PM (#30090150)
Do you remember which chapters (or other resources) talk about heap & mvcc specifically?
Re:The Internals of PostgreSQL by luhn on Wednesday January 26, 2022 @02:59PM (#30090859)
The heap is described in 1.3 [1] and MVCC is described in Chapter 5 [2]. I'd also recommend the Postgres docs [3], they aren't quite as accessible as this but are detailed and overall well-written.

[1] https://www.interdb.jp/pg/pgsql01.html#_1.3.

[2] https://www.interdb.jp/pg/pgsql05.html

[3] https://www.postgresql.org/docs/14/internals.html