1min.

1MIN · DATABASES

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

More engineering ideas, one minute at a time.

Explore more stories