Hacker GitHub

← All repos

ankane/dexter

View on GitHub ↗ ★ 2,095 Ruby

The automatic indexer for Postgres

11 mentions on Hacker News by 11 people: 2 stories, 9 comments · first 2017-07-10 · latest 2024-04-14

Mentions per year 11 mentions · busiest year 2017 (2)
20082026
AllStoriesComments NewestTopOldest
  1. Andrew Kane built dexter, which is an automatic indexer for Postgres. https://github.com/ankane/dexter https://ankane.org/introducing-dexter
    comment by b3lm0nt · 2024-04-14 · in Show HN: PostgreSQL index advisor
  2. dexter uses a similar premise with hypog. https://github.com/ankane/dexter
    comment by jensenbox · 2024-04-14 · in Show HN: PostgreSQL index advisor
  3. https://github.com/ankane/dexter
    comment by brunoqc · 2023-11-18 · in An automatic indexing system for Postgres
  4. …to optimize. An interesting project to manage indexes on postgres that seems tangentially related: https://github.com/ankane/dexter
    comment by jaggederest · 2022-12-28 · in SQLite's Automatic Indexes
  5. …to actually implementing it here: https://www.percona.com/blog/2019/07/22/automatic-index-reco... https://github.com/ankane/dexter is an autoindexer project that builds on hypopg, and I believe it can be configured to autocreate indices —…
    comment by code_biologist · 2022-07-05 · in Why Can't Database Tables Index Themselves? (2006)
  6. If you're using Postgres, check out dexter[0]. [0]: https://github.com/ankane/dexter
    comment by RussianCow · 2021-03-10 · in Ideas to improve the user and developer experiences of databases
  7. I was recently looking into this exact topic and found Dexter[1], which also uses HypoPG. [1] https://github.com/ankane/dexter
    comment by spencerhakim · 2019-07-24 · in Automatic Index Recommendations in PostgreSQL using pg_qualstats and hypopg
  8. …actually built yet. The “what-if” API is used to simulate such hypothetical indexes. Reminds me of https://github.com/ankane/dexter with https://github.com/HypoPG/hypopg .
    comment by striking · 2018-09-28 · in Columnstore and B+ tree – are hybrid physical designs important?
  9. …just a start, but have you seen HypoPG[0] and Dexter[1]? 0. https://github.com/dalibo/hypopg 1. https://github.com/ankane/dexter
    comment by mwpmaybe · 2017-10-05 · in PostgreSQL 10 Released