- Mastering PostgreSQL 9.6
- Hans Jurgen Schonig
- 133字
- 2021-07-09 19:57:20
Understanding how GiST works
To many people, GiST is still a black box. Therefore, I have decided to add a section to this section outlining how GiST works internally.
Consider the following diagram:

Figure 3.1: Source: http://leopard.in.ua/assets/images/postgresql/pg_indexes/pg_indexes2.jpg
Take a look at the tree. You will see that R1 and R2 are on top. R1 and R2 are the bounding boxes containing everything else. R3, R4, and R5 are contained by R1. R8, R9, and R10 are contained by R3 and so on. A GiST index is therefore hierarchically organized. What you can see in the diagram is that some operations, which are not available in B-trees are supported. Some of those operations are overlaps, left of, right of, and so on. The layout of a GiST tree is ideal for geometric indexing.
推薦閱讀
- 繪制進程圖:可視化D++語言(第1冊)
- 玩轉智能機器人程小奔
- 樂高創意機器人教程(中級 下冊 10~16歲) (青少年iCAN+創新創意實踐指導叢書)
- STM32G4入門與電機控制實戰:基于X-CUBE-MCSDK的無刷直流電機與永磁同步電機控制實現
- Mastering Machine Learning Algorithms
- Moodle Course Design Best Practices
- Android游戲開發案例與關鍵技術
- 工業機器人運動仿真編程實踐:基于Android和OpenGL
- 突破,Objective-C開發速學手冊
- 筆記本電腦維修90個精選實例
- Mastering Ceph
- 基于Proteus的單片機應用技術
- 電動汽車驅動與控制技術
- 玩機器人 學單片機
- Outlook時間管理秘笈