pgsql: Adjustments to the btree fastpath optimization.

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема pgsql: Adjustments to the btree fastpath optimization.
Дата
Msg-id E1f61dy-0000qp-RW@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
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(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Put back parallel-safety guards in plpython andsrc/test/regress
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: pgsql: Optimize btree insertions for common case of increasingvalues