News for hackers. Stuff that matters.
Re:Oracle vs. PostgreSQL: First Glance by zip1234 on Monday May 04, 2020 @10:29AM (#23068474)
Does PostgreSQL have bitmap indexes. Very much a great feature that Oracle has for query performance
Re:Oracle vs. PostgreSQL: First Glance by atombender on Monday May 04, 2020 @10:50AM (#23068723)
No. 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.
Re:Oracle vs. PostgreSQL: First Glance by anarazel on Monday May 04, 2020 @11:45AM (#23069377)
BRIN indexes are kind of bitmap like...
Re:Oracle vs. PostgreSQL: First Glance by fanf2 on Monday May 04, 2020 @10:45AM (#23068671)
Looks 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://www.postgresql.org/docs/current/indexes-bitmap-scans...