Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
I had detailed discussion about this with my mentor. Sorry, I didn't share details on hackers list.B-tree, gist, spgist, and gin are all tree based indexes where we scan and acquire predicate lockon only some and not all internal pages or leaf pages. So, here we have scope to reduce false positives. In BRIN index, each tuple stores summarizing values in the consecutive group of heap pages. So initially I thought we could implement tuple level predicate locking in BRIN. But, here we scanthe whole index which forces us to acquire predicate lock on all tuples. Acquiring predicate lock on alltuples will be no different than a relation level predicate lock.
В списке pgsql-hackers по дате отправления: