In buffer README, I see “Pins may not be held across transaction boundaries, however.” I think for different
transactions,they can pin the same buffer page, why not? For concurrent read transactions, they could read the one and
thesame buffer page.
On Fri, Sep 15, 2023 at 4:08 AM jacktby jacktby <jacktby@gmail.com> wrote:
In buffer README, I see “Pins may not be held across transaction boundaries, however.” I think for different transactions, they can pin the same buffer page, why not? For concurrent read transactions, they could read the one and the same buffer page.
You are right that different transactions can pin the same buffer,
but that does not conflict with what the README says, which is talking
about once the transaction is completed, all the Pins are removed.