pgsql: Adjustments to the btree fastpath optimization.

Started by Andrew Dunstanabout 8 years ago1 messagescomitters
Jump to latest
#1Andrew Dunstan
andrew@dunslane.net

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(-)