Horton

Add predicate locking for GiST

Teodor Sigaev <teodor@sigaev.ru>

View on postgr.es
Commit: 3ad55863e9392bff73377911ebbf9760027ed405
Author: Teodor Sigaev <teodor@sigaev.ru>
Date: 2018-03-27T12:43:19Z
Releases: 11.0 
Add predicate locking for GiST

Add page-level predicate locking, due to gist's code organization, patch seems
close to trivial: add check before page changing, add predicate lock before page
scanning.  Although choosing right place to check is not simple: it should not
be called during index build, it should support insertion of new downlink and so
on.

Author: Shubham Barai with editorization by me and Alexander Korotkov
Reviewed by: Alexander Korotkov, Andrey Borodin, me
Discussion: https://www.postgresql.org/message-id/flat/CALxAEPtdcANpw5ePU3LvnTP8HCENFw6wygupQAyNBgD-sG3h0g@mail.gmail.com

Files

PathChange+/−
src/backend/access/gist/gist.c modified +12 −1
src/backend/access/gist/gistget.c modified +3 −0
src/backend/storage/lmgr/README-SSI modified +3 −2
src/test/isolation/expected/predicate-gist.out added +659 −0
src/test/isolation/isolation_schedule modified +1 −0
src/test/isolation/specs/predicate-gist.spec added +117 −0

Discussion