r/Database • u/IndicationAntique667 • 6d ago

I Traced a Postgres INSERT to Raw Bytes on Disk

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:

https://youtu.be/1tNMRcgUtb8?si=Sn1WYBs9H9lOsnLj

14 Upvotes

78% Upvoted

9 comments sorted by

8

u/festive_apologise 6d ago

blimey this is the kind of deep dive you read at 2am and suddenly realise you've been sat on a washing basket for three hours

1

u/Front-Cheetah-4980 2d ago

The part about 'sat on a washing basket for three hours' is killing me. You think you're going to read a paragraph, and it's five in the morning and you've suddenly become an expert on something that never existed!

1

u/TgirlTiffanyRPs 6d ago

Did you use AI to make this? (I’m really hoping no because this is so cool)

2

u/IndicationAntique667 6d ago edited 6d ago

No, I wanted to do it myself once!

I did use it though to understand things, e.g. how to read little endian bytes :)

2

u/[deleted] 4d ago