pgsql: Adjustments to the btree fastpath optimization.
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: /messages/by-id/CABOikdO8jhRarNC60nZLktZYhxt+TK8z_V97+Ny499YQdyAfug@mail.gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/074251db6740a9abfbd922d13d39b27c4f338a20
Modified Files
--------------
src/backend/access/nbtree/README | 19 +++++++++++
src/backend/access/nbtree/nbtinsert.c | 63 +++++++++++++++++++++++++++++------
2 files changed, 71 insertions(+), 11 deletions(-)