Database Internals
page
the 8KB unit of ALL I/O tuple = one row version WAL = write-ahead log, the append-only truth LSN = a byte position in the WAL
Source board
This definition comes from the board below. Open it to see the term in context.
The MapDatabase InternalsMore terms from this board
- buffer poolpage cache in RAM dirty = changed in RAM only checkpoint = 'all dirty pages <= this LSN are on disk' MVCC = readers get a snapshot, never block
- vacuumcollect dead row versions latch = lock on a data structure (microseconds) lock = lock on data (whole txns) fsync = 'disk, PROMISE me it is durable'