- Mastering PostgreSQL 12
- Hans Jürgen Sch?nig
- 129字
- 2021-08-20 10:00:29
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.
推薦閱讀
- Hands-On Data Science with SQL Server 2017
- 2018西門子工業(yè)專家會議論文集(上)
- 機器自動化控制器原理與應用
- INSTANT Varnish Cache How-to
- Ceph:Designing and Implementing Scalable Storage Systems
- Red Hat Linux 9實務自學手冊
- 中國戰(zhàn)略性新興產業(yè)研究與發(fā)展·智能制造裝備
- Linux嵌入式系統(tǒng)開發(fā)
- 人工智能技術入門
- Visual Studio 2010 (C#) Windows數據庫項目開發(fā)
- 學練一本通:51單片機應用技術
- Learning ServiceNow
- 三菱FX/Q系列PLC工程實例詳解
- 電腦故障排除與維護終極技巧金典
- 計算機應用基礎實訓(職業(yè)模塊)