29th September 2022: PostgreSQL 15 RC 1 Released!

hypopg 1.1.0 released

Posted on 2017-10-05 by Dalibo

Version 1.1.0 of hypopg has just been released.

hypopg is a PostgreSQL extension adding support for hypothetical indexes.

An hypothetical, or virtual, index is an index that doesn't really exist, and thus doesn't cost CPU, disk, or any resource to create. They're useful to know if specific indexes might increase performance for problematic queries, since you could know if PostgreSQL will use these indexes or not without having to spend resources to create them.

This release adds support for hypothetical indexes on expression, an hypopg_get_indexdef() function to get the SQL command that will create the real index corresponding to a stored hypothetical index, PostgreSQL 10 compatiiblity, and bug fixes.

Please see the changelog for more details.

Many thanks to Andrew Kane and Rob Stolarz for reporting issues.

Source repository: github.com/dalibo/hypopg