liveBook · Manning

Hypopg

As explained in Just Use Postgres!

hypopg is a PostgreSQL extension that creates hypothetical indexes for evaluating indexing strategies without physically building them.

hypopg is a PostgreSQL extension for testing indexing strategies without physically creating the indexes. section 7.3

Use hypopg for query and performance optimization when comparing possible indexes.

  • Evaluate alternative indexing strategies without creating real indexes. section 7.3
  • Pair its hypothetical-index capability with tools such as pg_stat_statements and auto_explain when investigating query performance. section 7.3

How Just Use Postgres! covers it

How deep it goes
Defines hypothetical indexes and their purpose without detailing implementation or execution-plan mechanics.
What it assumes
Assumes familiarity with PostgreSQL extensions and query performance optimization.
What you can do after
Evaluate indexing strategies without physically building the candidate indexes.
How it connects
Connects with pg_stat_statements and auto_explain as PostgreSQL extensions for analyzing and improving query performance.
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.