- Mastering PostgreSQL 10
- Hans Jürgen Sch?nig
- 133字
- 2021-06-30 19:03:57
Understanding how GiST works
To many people, GiST is still a black box. Therefore, I have decided to add a section to this chapter 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.
推薦閱讀
- 大數據管理系統
- Canvas LMS Course Design
- Getting Started with Oracle SOA B2B Integration:A Hands-On Tutorial
- Dreamweaver 8中文版商業案例精粹
- Associations and Correlations
- AI 3.0
- 具比例時滯遞歸神經網絡的穩定性及其仿真與應用
- Windows Server 2003系統安全管理
- 計算機組網技術
- 水晶石影視動畫精粹:After Effects & Nuke 影視后期合成
- Embedded Linux Development using Yocto Projects(Second Edition)
- Mastering MongoDB 4.x
- 網絡信息安全項目教程
- 特征工程入門與實踐
- Flash 8中文版全程自學手冊