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

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:

Take a look at the tree. You will see that R1 and R2 are on top. R1 and R2 are the bounding boxes that contain 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 preceding diagram is that some operations that aren't 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.

主站蜘蛛池模板: 明光市| 察雅县| 吴桥县| 岑巩县| 景谷| 五寨县| 九台市| 通州市| 龙口市| 清远市| 镇平县| 鄄城县| 平湖市| 广东省| 祁连县| 兰州市| 诸暨市| 唐河县| 泾源县| 万盛区| 高尔夫| 望奎县| 长乐市| 陇川县| 女性| 平谷区| 汶上县| 长岛县| 武隆县| 梅河口市| 昌邑市| 宿州市| 新民市| 于田县| 百色市| 长岭县| 石阡县| 阳谷县| 化隆| 滨州市| 通辽市|