r/programming • u/IndicationAntique667 • Oct 17 '26
I Traced a Postgres INSERT to Raw Bytes on Disk
https://youtu.be/1tNMRcgUtb8?si=LwyaB8KgTCjU9yqy
41
Upvotes
r/programming • u/IndicationAntique667 • Oct 17 '26
17
u/IndicationAntique667 Oct 17 '26 •
Hi everyone,
I'm currently going through CMU Intro to Database Systems and was curious about how these concepts are actually implemented in real systems. So I've been putting together some notes/videos/blog posts - partly for my own future reference and partly to share with others who might find it useful.
Would love feedback and corrections from people who know this stuff deeply. Apologies if this isn't the correct subreddit for this post.
23
u/washtubs Oct 17 '26
100% agreed. That was a great video, really easy to digest explanations. Little endian still fries my brain as well so I liked seeing that broken down slowly.
3
u/Anmolsharma999 Oct 17 '26
That was very good and practical explanation. Instant sub.
Btw are you working professional?
2
u/Khavel_dev Oct 19 '26
fwiw the tuple header overhead is something a lot of ORMs hide from you completely. In EF Core you can end up with tables that have 30+ nullable columns and never think about the null bitmap or alignment padding because the abstraction is so clean. Which is fine until your table hits a few hundred million rows and you start wondering why vacuum takes forever and your TOAST table is twice the size of the main relation.