search

HypoPG / hypopg

Hypothetical Indexes for PostgreSQL
https://hypopg.readthedocs.io
Other
1.39k stars 59 forks source link

What are the use cases of this index #3

Closed amosbird closed 7 years ago

amosbird commented 7 years ago

Hi, according to the README.md, I fail to see any use cases of this index. Do you mind adding some examples?

rjuju commented 7 years ago

Hello,

I'm not sure I understand your question. hypopg isn't a new index type, it's just a way to know if postgres would use a given index if it existed before spending too much time/resources to really create it. This features exists on other RDBMS, usually also name hypothetical indexes or virtual indexes.

I wrote a blog post about this extension, is it helpful?

amosbird commented 7 years ago

Ah, thanks for the info. Your blog is really helpful :+1: