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