官术网_书友最值得收藏!

  • Mastering PostgreSQL 9.6
  • Hans Jurgen Schonig
  • 93字
  • 2021-07-09 19:57:21

SP-GiST indexes

Space partitioned GiST (SP-GiST) has mainly been designed for in-memory use. The reason for that is that an SP-GiST stored on disk needs a fairly high number of disk hits to function. Disk hits are way more expensive than just following a couple of pointers in RAM.

The beauty is that SP-GiST can be used to implement various types of trees such as quad-trees, k-d trees, and radix trees (tries).

The following strategies are provided:

To write your own operator classes for SP-GiST, a couple of functions have to be provided:

主站蜘蛛池模板: 井研县| 七台河市| 剑阁县| 铅山县| 海淀区| 黎川县| 西宁市| 绩溪县| 丹巴县| 宁蒗| 临漳县| 武义县| 京山县| 江安县| 翁牛特旗| 江都市| 绍兴县| 武穴市| 项城市| 始兴县| 玉树县| 宁南县| 三原县| 黄梅县| 东港市| 阳江市| 鲁山县| 潞城市| 洛南县| 中方县| 新闻| 四会市| 二连浩特市| 昆山市| 乐都县| 图们市| 宁南县| 遂昌县| 松桃| 册亨县| 炉霍县|