liveBook · Manning

Hypothetical index

As explained in Just Use Postgres!

A hypothetical index is a simulated database index represented to the query planner without being physically created.

A hypothetical index is a simulated index represented to the query planner without being physically created. It lets developers test indexing strategies while investigating query performance. section 7.3

Testing an indexing strategy

The hypopg Postgres extension adds support for hypothetical indexes, allowing candidate indexing strategies to be tested without creating real indexes. section 7.3

How Just Use Postgres! covers it

How deep it goes
Defines simulated indexes and their purpose, but does not detail commands, planner internals, or execution output.
Examples
Uses hypopg as the concrete extension for testing indexes without physically creating them.
What you can do after
Evaluate indexing strategies without creating real indexes.
How it connects
Connects query planning with indexing strategies and query execution statistics.
Cover of Just Use Postgres!
liveBookmanning.com
Read Just Use Postgres! on liveBook Get the book at manning.com

Related concepts

This explainer was generated by Manning's knowledge graph from the text of Just Use Postgres!. The section links point to the parts of the book it draws on.