You link to table level locks which are different from advisory locks: https://www.postgresql.org/docs/current/explicit-locking.html#ADVISORY-LOCKS https://www.

You link to table level locks which are different from advisory locks: https://www.postgresql.org/docs/current/explicit-locking.html#ADVISORY-LOCKS https://www.postgresql.org/docs/current/explicit-locking.htm... Are you sure that you're talking about the same locks? What are the pitfalls exactly?