Skip to content
This repository has been archived by the owner on Dec 7, 2018. It is now read-only.

Cursor Isolation

Jump to bottom
mdcallag edited this page Nov 26, 2014 · 17 revisions

Features

  • Read committed and repeatable read will be provided. A snapshot per statement will be used for read committed. A snapshot per transaction will be used for repeatable read.
  • TODO - determine whether locking-reads (those done by SELECT FOR UPDATE, INSERT, UPDATE, DELETE) use consistent or current reads.
  • Rows matched for locking-reads are locked until commit or rollback. TODO -- determine whether early unlock can be done for rows when the row does not match non-index predicates.
Clone this wiki locally