Arrange to cache btree metapage data in the relcache entry for the index,
Tom Lane <tgl@sss.pgh.pa.us>
Arrange to cache btree metapage data in the relcache entry for the index, thereby saving a visit to the metapage in most index searches/updates. This wouldn't actually save any I/O (since in the old regime the metapage generally stayed in cache anyway), but it does provide a useful decrease in bufmgr traffic in high-contention scenarios. Per my recent proposal.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/access/nbtree/nbtinsert.c | modified | +9 −2 |
| src/backend/access/nbtree/nbtpage.c | modified | +72 −2 |
| src/backend/access/nbtree/nbtree.c | modified | +13 −1 |
| src/backend/access/nbtree/README | modified | +12 −2 |
| src/backend/utils/cache/relcache.c | modified | +7 −1 |
| src/include/utils/rel.h | modified | +9 −1 |