Launching today
IndexPilot
Make a Postgres index prove itself before merge
7 followers
Make a Postgres index prove itself before merge
7 followers
Stop guessing which PostgreSQL indexes deserve to ship. IndexPilot checks proposals against real usage and existing indexes, helping you avoid wasted write, storage, and maintenance costs. Try it database-free in 60 seconds. It never changes your database.
Hi Product Hunters 👋
I read an article about how DNA can store large volumes of data and wondered why nobody had built a database with it. I soon understood that it was too complex and slow for a practical database. I kept the idea, and while trying to optimize the database for an algorithmic trading system I am building, I accidentally built IndexPilot. The idea pivoted toward indexing and efficiency.
IndexPilot is a free, open-source, read-only CLI that checks proposed PostgreSQL indexes against workload evidence before merge. @krshs90 joined the journey and contributed to the project. Please try the 60-second database-free review and tell me what worked, what failed, and what evidence you still need. If you use it, I would also value your honest review. If you are an expert in DB please join the project as contributor or for feedback and suggestions on github.
Thank you!
Jai
A 60-second database-free trial is a smart way to get people hooked. One thing that would help me trust it more: show me exactly which queries you sampled to decide a proposed index is actually beneficial, or let me upload a pg_stat_statements snapshot so the analysis matches my real workload instead of synthetic traffic.
Cool that you can try it without touching the database first. One thing I'd love is a way to schedule recurring audits, maybe weekly, with a diff report so I can see when new proposals appear and how my indexes drift over time.
Tried the database-free demo and was surprised how fast it flagged a duplicate index I'd been ignoring for months. Wish I'd had this before that last migration.