Ujjwal Agarwal

What Actually Happens Inside PostgreSQL When You UPDATE a Row?

Most developers think of a PostgreSQL table like this: users ---------------- id | age ---------------- 1 | 25 2 | 31 3 | 42 Then we run: UPDATE users SET age = 30 WHERE id = 1; The obvious menta