Explore our journey of optimizing PostgreSQL queries: from stubborn index rejections to achieving a 70x speed improvement with strategic adjustments

Lobsters is a community-driven platform for sharing and discussing links to articles, tutorials, and projects related to technology and programming. Readers can learn about a wide range of topics, from software development and system administration to cybersecurity and artificial intelligence. With user submissions, comments, and voting, Lobsters provides a platform for collaborative learning and knowledge sharing among technology enthusiasts.

Lobsters

Explore the journey of optimizing PostgreSQL queries, from facing rejection of adding an index to eventually achieving a significant reduction in query latency by refreshing the database's stale estimates.

That time PostgreSQL said "no thanks, I don't need your index"

Fun article. Postgresql is probably one of those i-know-better colleagues who refuse every attempt from others telling how it should work.

My favorite line:
<blockquote>
Let’s run it in prod! YOLO!
</blockquote>
Jokes aside, I love to read tales from the trenches

Good article, not just informative but also very clear