MVCC

Multi-Version Concurrency Control — instead of overwriting a row, the database writes a new version and marks the old one for cleanup later, letting readers and writers proceed without blocking.