5 docs tagged with "locking"

Deep-dive into core banking debit posting — ledger mechanics, memo vs. hard post, balance contention, idempotency, locking strategies, saga compensation, and production Java/Spring implementation patterns.

Strategies for dealing with race conditions, concurrent writes, hot spots, and lock contention in distributed systems including optimistic locking, MVCC, distributed locks, and queue-based serialization.

Exhaustive analysis of the 5 lock types: version column, SELECT FOR UPDATE, advisory locks, lock columns, and Redis locks; physical lifespans, failure modes, and why optimistic retry storms crush high-contention ticketing systems.

ACID properties, isolation levels, locking mechanisms, MVCC, deadlocks, and optimistic vs pessimistic concurrency.

Physical engine mechanics of PostgreSQL row locking: how xmax writes locks directly into tuple headers without a lock table, the 4 row lock modes matrix, foreign key collisions, EvalPlanQual rechecks, and why SSI serializable aborts are by design.