CODEWITHSUNDEEP
postgresql
inferno
inferno

Reputation: 774

What ever happened to on disk bitmap indexes?

Now PostgreSQL does not support bitmap index. I found that someone tried to implement it before.

Anyone knows what ever happened that it didn't get merged?

Upvotes: 0

Views: 59

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246463

Bitmap indexes are mostly useless: they make DML very hard.

PostgreSQL doesn't need them, because it has something much better: bitmap index scans. They can operate on regular B-tree indexes and have practically all advantages of bitmap indexes.

What happened to the patch: according to my reading of the thread, it just never got in commitable shape, and the discussion on its merits didn't get anywhere.

Upvotes: 1

Related Questions