How Postgres Writes Data: WAL, Shared Buffers, and the Illusion of Speed

As developers, we interact with databases every single day. We write a line of code like UPDATE users SET status = 'active' WHERE id = 42;, hit enter, and within a fraction of a millisecond, our termi...