News Score: Score the News, Sort the News, Rewrite the Headlines

Bridged Indexes in OrioleDB: architecture, internals & everyday use?

Since version beta10 OrioleDB supports building indexes other than B-tree. Bridged indexes are meant to support these indexes on OrioleDB tables. 1. Why OrioleDB needs a “bridge”​ OrioleDB stores its table rows inside a B-tree built on a table primary key and keeps MVCC information in an undo log, so it can’t simply plug PostgreSQL’s existing Index Access Methods (GiST, GIN, SP-GiST, BRIN, …) into that structure. While PostgreSQL's Index Access Methods: reference a 6-byte ctid (block number and ...

Read more at orioledb.com

© News Score  score the news, sort the news, rewrite the headlines