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

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

主站蜘蛛池模板: 溧水县| 东光县| 皋兰县| 东平县| 刚察县| 宜宾县| 鹿泉市| 绥化市| 丰城市| 资阳市| 酒泉市| 东乌| 辽源市| 竹山县| 习水县| 镇安县| 井研县| 武城县| 商城县| 麻城市| 宜昌市| 靖宇县| 邯郸县| 军事| 神木县| 滦平县| 招远市| 无为县| 苏尼特右旗| 肇庆市| 鸡东县| 靖边县| 扶沟县| 昭苏县| 莆田市| 龙里县| 长岭县| 江安县| 禄丰县| 邯郸县| 柳河县|