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

  • 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:

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.

主站蜘蛛池模板: 阿拉善盟| 清水县| 嘉荫县| 富锦市| 读书| 宣汉县| 临安市| 馆陶县| 普定县| 武川县| 石城县| 临高县| 荔浦县| 阜新| 阿拉善右旗| 无棣县| 沐川县| 海晏县| 芒康县| 昭觉县| 卓尼县| 景泰县| 玉树县| 青铜峡市| 大化| 贺州市| 澎湖县| 兴化市| 乐亭县| 神农架林区| 馆陶县| 蒲城县| 霸州市| 磴口县| 蓬溪县| 镇雄县| 吴川市| 额尔古纳市| 金堂县| 眉山市| 元朗区|