Hacker News new | ask | show | jobs
by funcDropShadow 1458 days ago
> 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

Edited: Fixed the link to version 14.