- 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.
推薦閱讀
- Practical Data Analysis
- 計算機應(yīng)用
- 計算機應(yīng)用復(fù)習(xí)與練習(xí)
- 并行數(shù)據(jù)挖掘及性能優(yōu)化:關(guān)聯(lián)規(guī)則與數(shù)據(jù)相關(guān)性分析
- 樂高創(chuàng)意機器人教程(中級 下冊 10~16歲) (青少年iCAN+創(chuàng)新創(chuàng)意實踐指導(dǎo)叢書)
- 自動生產(chǎn)線的拆裝與調(diào)試
- 基于單片機的嵌入式工程開發(fā)詳解
- Mastering Game Development with Unreal Engine 4(Second Edition)
- 多媒體制作與應(yīng)用
- 精通數(shù)據(jù)科學(xué):從線性回歸到深度學(xué)習(xí)
- 水晶石影視動畫精粹:After Effects & Nuke 影視后期合成
- 計算智能算法及其生產(chǎn)調(diào)度應(yīng)用
- 菜鳥起飛電腦組裝·維護與故障排查
- 基于元胞自動機的人群疏散系統(tǒng)建模與分析
- SQL Server 2019 Administrator's Guide