Skip to main content

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

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.