- 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:

推薦閱讀
- 現(xiàn)代測控系統(tǒng)典型應(yīng)用實例
- 大學(xué)計算機信息技術(shù)導(dǎo)論
- 玩轉(zhuǎn)智能機器人程小奔
- 軟件架構(gòu)設(shè)計
- Spark編程基礎(chǔ)(Scala版)
- Verilog HDL數(shù)字系統(tǒng)設(shè)計入門與應(yīng)用實例
- Hands-On Cybersecurity with Blockchain
- 城市道路交通主動控制技術(shù)
- JBoss ESB Beginner’s Guide
- 21天學(xué)通C#
- Cloudera Administration Handbook
- JavaScript典型應(yīng)用與最佳實踐
- Learn CloudFormation
- 從零開始學(xué)PHP
- 手機游戲程序開發(fā)