For doing a simple equality query such as
EXPLAIN SELECT * FROM table where x = 1;
I see that a Bitmap Index scan is done using the BTree indexes. Apparently, Bitmap Index scans disable Hash indexes but I'm curious as to why? Wouldn't the query be faster if we can hash the pointer values and then run the page fetches afterwards?