HypoPG 1.4.5 fixes errors in hypothetical-index experiments
HypoPG 1.4.5 fixes an index-estimation error and relation-identifier handling that could crash hypothetical-index experiments. The PostgreSQL extension lets a session ask whether the planner would use an index without building it on disk. That helps narrow candidate indexes, but the simulated index is available to EXPLAIN planning only; it cannot be used to measure actual query execution.
Julien Rouhaud · HypoPG · Nov 2, 2026
Why it matters
Planner estimates are useful for screening ideas, provided they are not mistaken for measurements from a real index.
More context
Try the maintenance release in a test database with the extension installed, compare plans, then build promising indexes in a representative environment to measure them. Hypothetical indexes belong to the creating connection, so other sessions do not see them. The community announcement is dated November 2 and names a November 1 release.
Keep in mind
An estimated plan does not establish runtime speed, write overhead or storage use; extension access also depends on the database service and available packages.
Original read