Hacker News
- How Postgres chooses which index to use for a query https://pganalyze.com/blog/how-postgres-chooses-index 76 comments
- Fast Search Using PostgreSQL Trigram Indexes https://about.gitlab.com/2016/03/18/fast-search-using-postgresql-trigram-indexes/ 31 comments
- Automatic Index Recommendations in PostgreSQL using pg_qualstats and hypopg https://www.percona.com/blog/2019/07/22/automatic-index-recommendations-in-postgresql-using-pg_qualstats-and-hypopg/ 3 comments
Lobsters
- How not to use jsonb fields and their indexes in PostgreSQL https://vsevolod.net/postgresql-jsonb-index/ 9 comments databases
- Why Postgres Won't Always Use an Index http://robots.thoughtbot.com/why-postgres-wont-always-use-an-index 6 comments programming
- Flask-PG-Extras is a Flask extension to help gain insights about your PostgreSQL database which could be useful when trying to analyze and improve database performance. It gives you a few new Flask CLI commands to run to get index usage, buffer cache hit rates, query times, slow queries, etc. https://github.com/nickjj/flask-pg-extras 7 comments flask