Hacker GitHub

← All repos

HypoPG/hypopg

View on GitHub ↗ ★ 1,751 C

Hypothetical Indexes for PostgreSQL

10 mentions on Hacker News by 10 people: 3 stories, 7 comments · first 2018-09-28 · latest 2026-04-20

Mentions per year 10 mentions · busiest year 2022 (3)
20082026
  1. …proper columns or something, where you need to validate performance before committing to it. 0: https://github.com/HypoPG/hypopg
    comment by sgarland · 2026-04-20 · in What if database branching was easy?
  2. In Postgres land, hypopg: https://github.com/HypoPG/hypopg
    comment by hardwaresofton · 2022-07-06 · in The SQLite Index Suggester
  3. …around this, though I personally can't use most of it as the HypoPG extension isn't on AWS RDS. :( https://github.com/HypoPG/hypopg HypoPG is a PostgreSQL extension adding support for hypothetical indexes. An hypothetical -- or virtual --…
    comment by code_biologist · 2022-07-05 · in Why Can't Database Tables Index Themselves? (2006)
  4. …a very nice extension that can help you check if your index is helpful before actually creating it. https://github.com/HypoPG/hypopg
    comment by dikei · 2022-01-20 · in Postgres Indexes for Newbies
  5. …but just in case: - https://github.com/ossc-db : pg_dbms_stats, pg_store_plans, pg_hint_plan - https://github.com/HypoPG/hypopg
    comment by samokhvalov · 2021-05-28 · in PostgreSQL EXPLAIN Output Explained
  6. …from an automated solution, but any good advice is going to have to come from a human. [0] https://github.com/HypoPG/hypopg
    comment by malisper · 2019-05-20 · in A Tale of Query Optimization
  7. …is used to simulate such hypothetical indexes. Reminds me of https://github.com/ankane/dexter with https://github.com/HypoPG/hypopg .