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.
[ Parent
| on HN ]
Do you remember which chapters (or other resources) talk about heap & mvcc specifically?
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.