Hypopg Alternatives

Similar projects and alternatives to hypopg

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better hypopg alternative or higher similarity.

hypopg reviews and mentions

Posts with mentions or reviews of hypopg. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-04-13.
  • Show HN: PostgreSQL Index Advisor
    6 projects | news.ycombinator.com | 13 Apr 2024
    It works particularly well with pg_stat_statements[0] which tracks execution statistics of all SQL statements executed on your Postgres database.

    It leans heavily on HypoPG[1], an excellent extension to determine if PostgreSQL will use a given index without spending resources to create them.

    [0] pg_stat_statements: https://www.postgresql.org/docs/current/pgstatstatements.htm...

    [1] https://github.com/HypoPG/hypopg

  • YugabyteDB hypopg: hypothetical indexes
    1 project | dev.to | 4 Nov 2022
    This is an introduction to the hypopg PostgreSQL extension for YugabyteDB 2.15.3.0. Hypopg allows the creation of hypothetical indexes, so indexes that do not really exist. This means this allows you to see what an index would do if it were created, without it actually being created, and therefore not influencing anything on the database. YugabyteDB 2.15.3.0 is a preview version of the YugabyteDB database.
  • The SQLite Index Suggester
    2 projects | news.ycombinator.com | 5 Jul 2022
  • Why Can't Database Tables Index Themselves?
    2 projects | news.ycombinator.com | 5 Jul 2022
    There's a lot of good ecosystem stuff around this:

    https://github.com/HypoPG/hypopg

    HypoPG is a PostgreSQL extension adding support for hypothetical indexes.

    An hypothetical -- or virtual -- index is an index that doesn't really exists, and thus doesn't cost CPU, disk or any resource to create. They're useful to know if specific indexes can increase performance for problematic queries, since you can know if PostgreSQL will use these indexes or not without having to spend resources to create them.

    With one approach to using it here: https://www.percona.com/blog/2019/07/22/automatic-index-reco...

  • Postgres Indexes for Newbies
    1 project | news.ycombinator.com | 19 Jan 2022
  • PostgreSQL Explain Output Explained
    2 projects | news.ycombinator.com | 28 May 2021
  • A note from our sponsor - SaaSHub
    www.saashub.com | 7 May 2024
    SaaSHub helps you find the best software and product alternatives Learn more →

Stats

Basic hypopg repo stats
6
1,262
5.0
9 days ago

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com