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.
No comments yet, be the first one to post comment.