I have just released version 1.1.0 of hypopg. 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 (https://github.com/dalibo/hypopg/blob/master/CHANGELOG.md) for more details. Many thanks to Andrew Kane and Rob Stolarz for reporting issues. Source repository: https://github.com/dalibo/hypopg Regards. -- Sent via pgsql-announce mailing list (pgsql-announce@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-announce
