Show HN: PostgreSQL Index Advisor

1. index_advisor

   1 5 1,658 3.5 PLpgSQL

   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

2. InfluxDB

   www.influxdata.com featured

   InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

   

3. hypopg

   2 8 1,502 3.9 C

   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

4. PgHero

   3 16 8,490 8.0 Ruby

   A performance dashboard for Postgres

   

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

5. jopt2023

   4 1 0 1.5

   

   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

6. dexter

   5 3 1,992 8.7 Ruby

   The automatic indexer for Postgres

   

7. SaaSHub

   www.saashub.com featured

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

   

Suggest a related project