Bug fixes:
- Fix potentially uninitialized variables, thanks to Jeremy Finzel for the
report.
- Support hypothetical indexes on materialized view, thanks to Andrew Kane
for the report.
Miscellaneous:
- add support for PostgreSQL 11
New features:
- add support for hypothetical indexes on expression
- add a hypopg_get_indexdef() function to get definition of a stored
hypothetical index
Bug fixes:
- don't allow hypothetical unique or multi-column index if the AM doesn't
support it
- disallow hypothetical indexes on system columns (except OID)
- fix indexes using DESC clause and default NULLS ordering, thanks to
Andrew Kane for the report and test case.
- fix PostgreSQL 9.6+ support, thanks to Rob Stolarz for the report
Miscellaneous:
- add support for PostgreSQL 10
- fix memory leak in hypopg() function
- add support for PostgreSQL 9.6, thanks to Konstantin Mosolov for fixing some issues
- add support from new bloom access method (9.6+)
- fix issue with hypothetical indexes on expression (thanks to Konstantin Mosolov)
- fix possible crash in hypothetical index size estimation
- remove the simplified "hypopg_add_index()" function
- free memory when hypothetical index creation fails
- check that number of column is suitable for a real index
- for btree indexes, check that the estimated average row size is small enough to allow a real index creation.
- handle BRIN indexes.
- handle index storage parameters for supported index methods.
- handle index on predicate.
- safer handling of locks.
- fix a bug when a regular query could fail after a hypothetical index have been created, and tested with explain.
- hypopg_create_index() and hypopg_add_index() now returns the oid and index names.
- add hypopg.enabled GUC. It allows disabling HypoPG globally or in a single backend. Thanks to Ronan Dunklau for the patch.
- fix crash when building hypothetical index on expression, thanks to Thom Brown for the report.
- First version of HypoPG.