]> granicus.if.org Git - postgresql/commit
Microvacuum for GIST
authorTeodor Sigaev <teodor@sigaev.ru>
Wed, 9 Sep 2015 15:43:37 +0000 (18:43 +0300)
committerTeodor Sigaev <teodor@sigaev.ru>
Wed, 9 Sep 2015 15:43:37 +0000 (18:43 +0300)
commit013ebc0a7b7ea9c1b1ab7a3d4dd75ea121ea8ba7
treef22d59c51b1df33681b4dcc9e7160b6e6c0fa446
parent96f6a0cb41ee06673960019f0026b1b0fd1e644d
Microvacuum for GIST

Mark index tuple as dead if it's pointed by kill_prior_tuple during
ordinary (search) scan and remove it during insert process if there is no
enough space for new tuple to insert. This improves select performance
because index will not return tuple marked as dead and improves insert
performance because it reduces number of page split.

Anastasia Lubennikova <a.lubennikova@postgrespro.ru> with
 minor editorialization by me
src/backend/access/gist/gist.c
src/backend/access/gist/gistget.c
src/backend/access/gist/gistscan.c
src/include/access/gist.h
src/include/access/gist_private.h