Show HN: PostgreSQL Index Advisor

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  • index_advisor

    PostgreSQL Index Advisor

  • 2. Copy/paste the plpgsql file:

    https://github.com/supabase/index_advisor/blob/main/index_ad...

    We are also developing the Trusted Language Extension with the RDS team, so at some point it should be easier to do this through database.dev:

    https://database.dev/olirice/index_advisor

  • hypopg

    Hypothetical Indexes for PostgreSQL

  • 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

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
  • PgHero

    A performance dashboard for Postgres

  • I am using https://github.com/ankane/pghero/ and this is one of its features with GUI

  • jopt2023

  • If anyone has some background in optimization and is interested in the more technical side of things, I gave a talk at JOPT 2023, comparing MIP and CP approaches for this problem. The slides can be found here: https://github.com/PhilippeOlivier/jopt2023

  • dexter

    The automatic indexer for Postgres

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts