Transaction & Concurrency
Isolation levels, savepoints, advisory locks, and concurrency control.
0 features
but not in
Application-level, cooperative locks managed by the database engine but with semantics entirely controlled by the application.
advisory lockpg_advisory_lockGET_LOCKDBMS_LOCKapp locknamed locksp_getapplock
Postgres
MySQL
MariaDB
Oracle
SQL Server
SQLite
Redshift
DB2
Snowflake
BigQuery
Control the visibility of concurrent transaction changes: Read Uncommitted, Read Committed, Repeatable Read, and Serializable.
isolation levelREAD COMMITTEDREAD UNCOMMITTEDREPEATABLE READSERIALIZABLESNAPSHOTSET TRANSACTION ISOLATION LEVEL
Postgres
MySQL
MariaDB
Oracle
SQL Server
SQLite
Redshift
DB2
Snowflake
BigQuery
Asynchronous pub-sub messaging built into the database, where sessions can subscribe to channels and receive notifications from other sessions.
LISTENNOTIFYpg_notifypub-subnotificationasync notificationchannel
Postgres
MySQL
MariaDB
Oracle
SQL Server
SQLite
Redshift
DB2
Snowflake
BigQuery
How each database provides read consistency, rollback, and cleanup: row-version MVCC, undo/redo logs, version stores, WAL, vacuum, or snapshot-based storage.
mvccmultiversion concurrency controlrow versioningread consistencyversion storeundo logredo logwalvacuumpurge
Postgres
MySQL
MariaDB
Oracle
SQL Server
SQLite
Redshift
DB2
Snowflake
BigQuery
Named markers within a transaction that allow partial rollback without aborting the entire transaction.
savepointSAVEPOINTROLLBACK TO SAVEPOINTnested transaction
Postgres
MySQL
MariaDB
Oracle
SQL Server
SQLite
Redshift
DB2
Snowflake
BigQuery