Database Internals

vacuum

collect dead row versions latch = lock on a data structure (microseconds) lock = lock on data (whole txns) fsync = 'disk, PROMISE me it is durable'

Source board

This definition comes from the board below. Open it to see the term in context.

The MapDatabase Internals

More 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
pagethe 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