BufferPin
Short Description
Waiting to acquire a pin on a buffer
Detailed Description​
The server process is waiting for an exclusive lock on a shared memory buffer.
How to reduce this wait​
This wait can be seen when another process is using the buffer in an open cursor.
Look for:
- Long running transactions
- Orphaned sessions
- Vacuum sessions
Additional Links​
PostgreSQL documentation - The Statistics Collector
PostgreSQL documentation - Memory
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.