Hi Shubham, On Tue, Jun 27, 2017 at 9:21 PM, Shubham Barai <shubhambaraiss@gmail.com> wrote: > If these two hash keys (78988658 and 546789888) mapped to the same bucket, this will result in false serialization failure. > Please correct me if this assumption about false positives is wrong.
I wonder if there is an opportunity to use computed hash values directly in predicate lock tags, rather than doing it on the basis of buckets. Perhaps I'm missing something important about the way that locks need to escalate that would prevent that from working.
+1,
Very nice idea! Locking hash values directly seems to be superior over locking hash index pages. Shubham, do you have any comment on this?
------ Alexander Korotkov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company