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