Pre-release

@rjuju rjuju released this Dec 11, 2018

Assets 2

New features:

  • Add support for hypothetical partitioning, for pg10+ (Hosoya Yuzuko,
    Julien Rouhaud)

Miscellaneous

  • Use a dedicated MemoryContext to store hypothetical objects

Bug fixes:

  • Call previous explain_get_index_name_hook if it was setup
  • add hypopg_reset_index() SQL function

@rjuju rjuju released this May 30, 2018 · 82 commits to master since this release

Assets 2

New features

  • Add support for INCLUDE on hypothetical indexes (pg11+)
  • Add support for parallel hypothetical index scan (pg11+)

Bug fixes:

  • Fix support for pg11, thanks to Christoph Berg for the report

@rjuju rjuju released this Mar 29, 2018 · 89 commits to master since this release

Assets 2

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

@rjuju rjuju released this Oct 4, 2017 · 109 commits to master since this release

Assets 2

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

@rjuju rjuju released this Oct 24, 2016 · 129 commits to master since this release

Assets 2

hypopg is now stable.

Bug fix:

  • fix a memory leak in hypopg() function

@rjuju rjuju released this Oct 24, 2016 · 132 commits to master since this release

Assets 2

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-

@rjuju rjuju released this Dec 5, 2015 · 146 commits to master since this release

Assets 2

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

@rjuju rjuju released this Dec 5, 2015 · 186 commits to master since this release

Assets 2
  • 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.

@rjuju rjuju released this Dec 5, 2015 · 198 commits to master since this release

Assets 2

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

Pre-release
Pre-release

@rjuju rjuju released this Dec 5, 2015 · 202 commits to master since this release

Assets 2

First version of HypoPG.

Only simple hypothetical btree indexes are handled.