Understanding recovery conflict due to bufferpin

From: vinay kumar <vnykmr36(at)gmail(dot)com>
To: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Understanding recovery conflict due to bufferpin
Date: 2021-03-17 04:44:34
Message-ID: CAMdzBEkg+EytT1XcsykcsarpLVu+oQcDV4ekdf6CMjOv8JpvyA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi Team,

Need some understanding regarding recovery conflict due to buffer pin.

We see "User was holding shared buffer pin for too long" .

I understand that this can be due to holding lock to update content of a db
block or page.

1> Is the lock held on a buffer page or page at disk level?

2> Is there any serialization present to maintain the locking mechanism?

Thanks

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Laurenz Albe 2021-03-17 12:41:47 Re: Understanding recovery conflict due to bufferpin
Previous Message bee.lists 2021-03-15 12:19:04 Can't Start Server