]> granicus.if.org Git - postgresql/commit
Adjustments to the btree fastpath optimization.
authorAndrew Dunstan <andrew@dunslane.net>
Tue, 10 Apr 2018 22:21:03 +0000 (18:21 -0400)
committerAndrew Dunstan <andrew@dunslane.net>
Tue, 10 Apr 2018 22:21:03 +0000 (18:21 -0400)
commit074251db6740a9abfbd922d13d39b27c4f338a20
tree071d11111c9dfd3719c06314efb5582b3caf0628
parent31f1f0bb4fd642643994d35c35ecb5b929711a99
Adjustments to the btree fastpath optimization.

This optimization was introduced in commit 2b272734. The changes include
some additional comments and documentation, and also these more
substantive changes:
. ensure the optimization is only applied on the leaf node of a tree
whose root is on level 2 or more. It's of little value on small trees.
. Delay calling RelationSetTargetBlock() until after the critical
section of _bt_insertonpg
. ensure the optimization is also applied to unlogged tables.

Pavan Deolasee and Peter Geoghegan with some very light editing from me.

Discussion: https://postgr.es/m/CABOikdO8jhRarNC60nZLktZYhxt+TK8z_V97+Ny499YQdyAfug@mail.gmail.com
src/backend/access/nbtree/README
src/backend/access/nbtree/nbtinsert.c