From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Adjustments to the btree fastpath optimization. |
Date: | 2018-04-10 22:21:38 |
Message-ID: | E1f61dy-0000qp-RW@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2018-04-10 22:27:10 | Re: pgsql: Optimize btree insertions for common case of increasing values |
Previous Message | David Steele | 2018-04-10 21:45:12 | Re: pgsql: Validate page level checksums in base backups |