Glossary: PostgreSQL Beyond the Basics

Lock modes, lock queue

Also written: lock mode, lock queue

Lock modes are the different strengths of table lock. Locks are granted in order, so a waiting request, such as an ALTER TABLE, makes later queries queue behind it.