Re: Too coarse predicate locks granularity for B+ tree indexes

2023-02-07 Thread Rinat Shigapov
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: > &

Too coarse predicate locks granularity for B+ tree indexes

2023-02-07 Thread Rinat Shigapov
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