News for hackers. Stuff that matters.

A comment on Introducing HypoPG, hypothetical indexes for PostgreSQL. Parent comment

Re:Introducing HypoPG, hypothetical indexes for PostgreSQL by pizza234 on Wednesday June 24, 2015 @05:57PM (#9774765)
Watch out, the extension does not create "temporary indices". They can't be used in queries.

It only creates virtual indices, whose only purpose is to observe how the query optimizer would behave, if they were real.

I find it quite a curious idea, although an important parameter of the indices is the cardinality, which I don't see customizable.

[ Parent | on HN ]
Re:Introducing HypoPG, hypothetical indexes for PostgreSQL by kbenson on Wednesday June 24, 2015 @06:14PM (#9774840)
Yes, in this case hypothetical means conjecture. "Let's get information about how the system would function if there existed an index as such..."
[ Parent | on HN ]