I don't know much about database systems, so this might not help, but the PostGRESQL documentation appears relevant: http://www.postgresql.org/docs/9.3/static/mvcc-intro.html (be sure to read the sections that follow the introduction for details).