Thread: 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: https://postgr.es/m/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(-)