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

推薦閱讀
- 數據運營之路:掘金數據化時代
- 傳感器與新聞
- PostgreSQL 10 Administration Cookbook
- Chef:Powerful Infrastructure Automation
- 基于神經網絡的監督和半監督學習方法與遙感圖像智能解譯
- 工業自動化技術實訓指導
- Visual Studio 2010 (C#) Windows數據庫項目開發
- 基于敏捷開發的數據結構研究
- 水晶石影視動畫精粹:After Effects & Nuke 影視后期合成
- 案例解說Delphi典型控制應用
- 51單片機應用程序開發與實踐
- 網管員世界2009超值精華本
- Oracle 11g基礎與提高
- Hands-On Generative Adversarial Networks with Keras
- 大話數據科學:大數據與機器學習實戰(基于R語言)