3 ms·
> You can speed up, by a huge margin, big string indices with md5/hash index Dumb question: what's the use case for having a md5/hash field in your database?
by alberth 4y ago
> You can speed up, by a huge margin, big string indices with md5/hash index
Dumb question: what's the use case for having a md5/hash field in your database?
- __s 4y agoPostgres offers hash indexes as opposed to b-tree indexes: https://www.postgresql.org/docs/current/hash-intro.html https://www.postgresql.org/docs/current/hash-intro.html For equality comparisons of large types it's quite beneficial
- h1fra 4y agoI have answered here: https://news.ycombinator.com/item?id=35701126 https://news.ycombinator.com/item?id=35701126 In my case, I had to index big tables with URLs, with no need for partial match. I did it naively but did help a lot.