> so older databases like PostgreSQL will be using B+trees for the indefinite future even if suboptimal. PostgreSQL 14 comes with 6 builtin index types[1]: B-t

> so older databases like PostgreSQL will be using B+trees for the indefinite future even if suboptimal. PostgreSQL 14 comes with 6 builtin index types[1]: B-tree, Gist, SP-Gist, Gin, Brin, and Hash. More can be plugged in as extensions. [1]: Chapters 63-69 of https://www.postgresql.org/docs/14/internals.html https://www.postgresql.org/docs/14/internals.html Edited: Fixed the link to version 14.