PostgreSQL11preview-索引增強彙總
標籤
PostgreSQL , 索引 , 增強 , 11
背景
PostgreSQL 11 索引特性的增強。
E.1.3.1.3. Indexes
-
Allow indexes to INCLUDE columns that are not part of the unique constraint but are available for index-only scans (Anastasia Lubennikova, Alexander Korotkov, Teodor Sigaev)
This is also useful for including columns that don`t have btree support.
《PostgreSQL 11 preview 功能增強 – 唯一約束 + 附加欄位組合功能索引》
允許唯一約束索引中,使用INCLUDE包含非唯一約束的欄位的內容。甚至對於無法使用BTREE構建的欄位型別,也可以將它的欄位內容用include包含進來。類似b+tree的效果。
-
Remember the highest btree index page to optimize future monotonically increasing index additions (Pavan Deolasee, Peter Geoghegan)
-
Allow entire hash index pages to be scanned (Ashutosh Sharma)
Previously for each hash index entry, we need to refind the scan position within the page. This cuts down on lock/unlock traffic.
-
Add predicate locking for hash, GiST and GIN indexes (Shubham Barai)
This reduces the likelihood of serialization conflicts. ACCURATE?
-
Allow heap-only-tuple (HOT) updates for expression indexes when the values of the expressions are unchanged (Konstantin Knizhnik)
《PostgreSQL 11 preview – Surjective indexes – 索引HOT增強(表示式)update評估》
E.1.3.1.3.1. SP-Gist
-
Add TEXT prefix operator ^@ which is supported by SP-GiST (Ildus Kurbangaliev)
This is similar to using LIKE `word%` with btree indexes, but is more efficient.
允許SP-GiST索引支援字首模糊查詢(
^@
與LIKE `word%`
效果一致 ),並且效率比btree索引更高。 -
Allow polygons to be indexed with SP-GiST (Nikita Glukhov, Alexander Korotkov)
允許polygon型別使用SP-GiST索引 (空間分割槽索引)。
-
Allow SP-GiST indexes to optionally use compression (Teodor Sigaev, Heikki Linnakangas, Alexander Korotkov, Nikita Glukhov)
允許SP-GiST索引支援壓縮。
相關文章
- PostgreSQL11preview-平行計算增強彙總SQLView
- PostgreSQL11preview-分割槽表增強彙總SQLView
- PostgreSQL11preview-優化器增強彙總SQLView優化
- mysql 索引的基礎操作彙總MySql索引
- PostgreSQL11preview-索引優化。filter智慧消除、分割槽索引智慧合併SQLView索引優化Filter
- Oracle索引塊分裂split資訊彙總Oracle索引
- Pandas知識點彙總(2)——布林索引索引
- MySQL查詢最佳化方案彙總(索引相關)MySql索引
- [20181026]12c增強索引線上DDL操作.txt索引
- 影像增強演算法總結演算法
- Vagrant box 命令彙總彙總
- vue3 高階 API 大彙總,強到離譜VueAPI
- 索引總結索引
- jquery彙總jQuery
- 2018年最強自然語言模型 Google BERT 資源彙總模型Go
- AAAI 2020 | 52篇深度強化學習accept論文彙總AI強化學習
- 2020年全球獨角獸企業500強資料彙總
- mysql索引總結MySql索引
- ARM彙編指令集彙總
- 超強彙總:學習Python列表,只需這篇文章就夠了Python
- Git命令彙總Git
- 引數彙總
- VUE元件彙總Vue元件
- css 技巧彙總CSS
- 資料彙總
- artisan命令彙總
- vagrant命令彙總
- OP code彙總
- bookStore疑惑彙總
- IE功能彙總
- Python類彙總Python
- 彙總資料
- go 命令彙總Go
- gstreamer命令彙總
- git 命令彙總Git
- ClickHouse 命令彙總
- keycloak文章彙總
- SAP SD 實際應用增強(含程式碼)總結