3 ms·

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 th

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.

rattray 5y ago
Do you remember which chapters (or other resources) talk about heap & mvcc specifically?
- luhn 5y ago
  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 https://www.interdb.jp/pg/pgsql01.html#_1.3. [2] https://www.interdb.jp/pg/pgsql05.html https://www.interdb.jp/pg/pgsql05.html [3] https://www.postgresql.org/docs/14/internals.html https://www.postgresql.org/docs/14/internals.html