Posts tagged “locking”

• October 14, 2026 · Development

  MySQL InnoDB Gap Locks: What Gets Locked When the Row Doesn't Exist

  Why InnoDB locks gaps between index records under REPEATABLE READ, why check-then-insert with FOR SHARE can deadlock, and what READ COMMITTED gives up. Based on the MySQL 8.4 manual.

  mysqlinnodbdatabaseconcurrencylocking
• October 13, 2026 · Development

  PostgreSQL CREATE INDEX CONCURRENTLY: what you pay for not blocking writes

  CREATE INDEX CONCURRENTLY's lock, two scans and transaction waits, INVALID index cleanup after failure, and transaction-block and partition limits, per PostgreSQL 18 docs.

  postgresqlindexlockingdatabasemigration

No posts match. Try another word.