Bruce Momjian wrote: > Probably the most controvertial change was to move on-disk bitmap > indexes to the "not wanted" section, though I kept the links in case we > change our minds. I just can't see how they would be a win with GIN and > in-memory bitmaps.
Yeah, I recall we discussed bitmap indexes a lot and we found there wasn't a lot of room to use them because GIN is just too good, it seems. Also, the patches that were developed had a number of issues. Anyone wanting to develop bitmap indexes would probably be better off starting from scratch. > (I don't think BRIN indexes help for on-disk bitmap use-cases, do > they?) No, they don't. I expect BRIN to be very bad in a limited domain (which is where bitmap indexes are supposed to shine), except under specific conditions. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers