LockManager
Short Description
Waiting to read or update information about “heavyweight” locks.
Additional Information
PostgreSQL by default uses ‘fast path’ locks where possible as these are locks are light on resource utilisation. When use of ‘fast path’ locks is not possible, a ‘heavyweight’ lock will be used.
How to reduce this wait
Ensure PostgreSQL is using the current version.
Problems have been seen with TOAST storage and in heavily partitioned databases.
Additional Links
PostgreSQL docs - Wait Events of Type LWLock
Postgrepro - LWLocks by LockManager slowing large DB
Search online
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.