官术网_书友最值得收藏!

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.

主站蜘蛛池模板: 邢台县| 军事| 岳阳县| 桂阳县| 忻州市| 巴彦淖尔市| 垦利县| 凤台县| 柳河县| 伊吾县| 美姑县| 铜陵市| 南岸区| 通河县| 泸水县| 临朐县| 长沙市| 财经| 宁陵县| 文登市| 雅江县| 疏勒县| 汪清县| 金坛市| 衡阳县| 澄迈县| 泽库县| 同德县| 麻江县| 富源县| 和田县| 观塘区| 嵩明县| 华池县| 虎林市| 依安县| 岳普湖县| 达尔| 昭平县| 兴宁市| 永清县|