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+ny499yqdya...@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(-)