New posts in Locking

Should an INSERT cause an exclusive lock on a foreign key?

How to keep an unique counter per row with PostgreSQL?

Does a simple select query acquire locks?

Why is optimistic locking faster than pessimistic locking?

MySQL InnoDB locks primary key on delete even in READ COMMITTED

FIFO queue table for multiple workers in SQL Server

InnoDB row locking - how to implement

MySQL Locks while CREATE TABLE AS SELECT

What is lock escalation?

Is NOLOCK always bad?