spam Like Dislike

Re-Introducing Hash Indexes in PostgreSQL

published 796 days, 9 hours, 50 minutes ago posted by matthewpomarmatthewpomar 805 days, 13 hours, 35 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 12:59:22 PM GMT

There is a type of index you are probably not using, and may have never even heard of. It is wildly unpopular, and until a few PostgreSQL versions ago it was highly discouraged and borderline unusable, but under some circumstances it can out-perform even a B-Tree index.

After visiting this story, if you enjoyed it, please show the author some love by coming back and clicking Like button and leaving a comment.

category: PostgreSQL | clicked: 0 | | source: hakibenita.com | show counter code
tags: Performance, SQL

No comments yet, be the first one to post comment.

To post your comment please login or signup

Welcome PostgreSQL Developers!

Are you a PostgreSQL developer or interested in becoming one? DeveloperSites is here to help you find the most interesting, freshest PostgreSQL developer stories for you to sharpen your skills as a seasoned PostgreSQL developer or help you find resources that will help you become a PostgreSQL developer.

Here you will find the latest PostgreSQL blog posts, articles, books and more. The best stories are voted up by our growing PostgreSQL developer community.

Signup for free and join the DeveloperSites community today!