Postgres Locks
Introduction PostgreSQL provides various lock modes that control access to database tables. These modes can be used in various situations where multiversion concurrency control, or MVCC, does not produce the desired results. Some PostgreSQL commands automatically set locks to ensure referenced tables aren’t modified or dropped during command execution. Postgres locks, such as Write Locks … Continued