Database Internals

buffer pool

page cache in RAM dirty = changed in RAM only checkpoint = 'all dirty pages <= this LSN are on disk' MVCC = readers get a snapshot, never block

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

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
vacuumcollect dead row versions latch = lock on a data structure (microseconds) lock = lock on data (whole txns) fsync = 'disk, PROMISE me it is durable'