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

2023-02-07 Thread Rinat Shigapov
Thank you for your prompt reply! I've mentioned that I've generated ballast data to make the cost optimizer to switch to page-level locks. But my question is about more finer grained (less then page) predicate locks for indices. With page-level locks I could still get serialization failures if I

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

2023-02-07 Thread Laurenz Albe
On Tue, 2023-02-07 at 16:23 +0600, Rinat Shigapov wrote: > I have a concurrent testsuite that runs 14 test cases. Each test case operates > on a disjoint set of records, doesn't retry transactions and is run under > 'serializable' isolation level. The test data is small and likely fits within > a s