Concepts: Transactions

• Transaction: encapsulate work
• Two 'types' of transactions in Postgres: single query as transaction; BEGIN/COMMIT transaction block
• autocommit
• Transaction isolation: READ COMMIT, SERIALIZABLE


• Multiversion concurrency control
  • ensuring each transaction sees only objects valid for it
  • multiple versions of tuples stored on disk

Page 8