4 ms·
Does PostgreSQL have bitmap indexes. Very much a great feature that Oracle has for query performance
by zip1234 6y ago
Does PostgreSQL have bitmap indexes. Very much a great feature that Oracle has for query performance
- fanf2 6y agoLooks like PostgreSQL only has ephemeral bitmap indexes used when making a query that combines multiple indexes - https://leopard.in.ua/2015/04/13/postgresql-indexes https://leopard.in.ua/2015/04/13/postgresql-indexes - https://www.postgresql.org/docs/current/indexes-bitmap-scans.html https://www.postgresql.org/docs/current/indexes-bitmap-scans...
- atombender 6y agoNo. Postgres has in-memory bitmap indexes, which are built on the fly while scanning the index and used to more efficiently combine AND/OR clauses, but that's not quite the same thing. There have been several attempts at adding on-disk bitmap index support to Postgres, but they've all been abandoned.
- anarazel 6y agoBRIN indexes are kind of bitmap like...