Hi, On October 26, 2026 10:33:16 AM EDT, Greg Burd <[email protected]> wrote: >On 2026-10-26 Andres Freund wrote: >> I frankly think it's pretty much unacceptable for a niche index like hash >> to violate the rules like that. >> [...] >> It's probably the best answer in the back branches, but I think we >> shouldn't do this in master. > >Thanks for taking the time to review, I'm curious why you used the term >"niche" with hash indexes. Not related to this topic, just an aside.
I think they're almost unused and don't offer enough advantage over btree (and perform catastrophically bad in many cases). Instead of making them WAL logged a few years back; we should have just ripped them out. The advantage hash does have, i.e. large key handling, would have better been addressed by adding support to transparently btree indexing a hash of the key + recheck. Greetings, Andres -- Sent from my phone. Please excuse my brevity.
