database postgresql reading-list sql

Indexes can make a world of difference to performance in Postgres, but it's not always obvious when you've written a query that could do with an index. Here we'll cover:

  • What indexes are
  • Some use cases for when they're helpful
  • Rules of thumb for figuring out which sort of index to add
  • How to identify when you're missing an index
continue reading on incident.io

⚠️ This post links to an external website. ⚠️

You might also like:

If this post was enjoyable or useful for you, please share it! If you have comments, questions, or feedback, you can email my personal email. To get new posts, subscribe use the RSS feed.