Updates

• Page latch held in X mode until log record is logged

  • so updates on same page are logged in correct order
  • page latch held in S mode during reads since records may get moved around by update
  • latch required even with page locking if dirty reads are allowed

• Log latch acquired when inserting in log

Notes: