Thomas, thank you for the details!
Have you kept the branch that you used to generate the patch? Which commit
should the patch apply to?
With kindest regards, Rinat Shigapov
вт, 7 февр. 2023 г. в 17:11, Thomas Munro :
> On Tue, Feb 7, 2023 at 11:24 PM Rinat Shigapov
> wrote:
> &
on each run.
I started to read more about SSI implementation in PostgreSQL. The article
https://arxiv.org/pdf/1208.4179.pdf mentions that
> Currently, locks on B+-tree indexes are acquired at page granularity; we
> intend to refine this to next-key locking [16] in a future release.
>
[16] C. Mohan. ARIES/KVL: A key-value locking method for concurrency
> control of multiaction transactions operating on B-tree indexes. In VLDB,
> pages 392–405, 1990.
My question follows:
Does the current PostgreSQL release support B+ tree index predicate locks
more granular then page-level locks?
With kindest regards, Rinat Shigapov