Skip to content

Releases: HypoPG/hypopg

version 1.1.0

04 Oct 17:37
Compare
Choose a tag to compare

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

version 1.0.0

24 Oct 15:25
Compare
Choose a tag to compare

hypopg is now stable.

Bug fix:

  • fix a memory leak in hypopg() function

version 0.0.5

24 Oct 13:41
Compare
Choose a tag to compare

New features:

  • add support for PostgreSQL 9.6, thanks to Konstantin Mosolov for fixing some
    issues
  • add support from new bloom access method (9.6+)

Bug fixes:

  • fix issue with hypothetical indexes on expression (thanks to Konstantin
    Mosolov)
  • fix possible crash in hypothetical index size estimation
  • fix compatibility with pg 9.4-

version 0.0.4

05 Dec 15:04
Compare
Choose a tag to compare

New features:

  • add support for BRIN indexes (for pg 9.5+ obviously).
  • handle index on predicate.
  • handle index storage parameters for supported index methods. For now, this means :
    • fillfactor for btree indexes
    • pages_per_range for brin indexes

Bug fixes or improvements:

  • check that number of column is suitable for a real index
  • free memory when hypothetical index creation fails
  • for btree indexes, check that the estimated average row size is small enough to allow a real index creation.
  • safer handling of locks.

Misc:

  • remove the simplified "hypopg_add_index()" function

version 0.0.3

05 Dec 15:00
Compare
Choose a tag to compare
  • 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.

version 0.0.2

05 Dec 14:58
Compare
Choose a tag to compare

Fix https://github.com/dalibo/hypopg/issues/1 : server crash when trying to create an hypothetical functional index.

version 0.0.1

05 Dec 14:57
Compare
Choose a tag to compare
version 0.0.1 Pre-release
Pre-release

First version of HypoPG.

Only simple hypothetical btree indexes are handled.