Get the latest tech news
Bridged Indexes in OrioleDB: architecture, internals and everyday use?
Since version beta10 OrioleDB supports building indexes other than B-tree. Bridged indexes are meant to support these indexes on OrioleDB tables.
The vacuum process collects stale iptr-s that are not visible to any snapshot, and asks the underlying IndexAM to clean up; then physically deletes the same pointers from the bridge index. 3.2 Manual control (when you need it) You may prepare the bridge layer on the table in advance to save time during adding an index. Modern, MVCC-aware, index-organized storage for the table itself; Full access to Postgres’ rich IndexAM ecosystem — GIN for full-text, GiST for spatial, pgvector’s HNSW, RUM, BRIN and more — without rewriting those extensions.
Or read this on Hacker News
