Often when talking about optimizing data SQL in web applications we focus on the application layer concerns like n+1 queries and the like, but occasionally we'll need to dive down into the database layer itself to optimize our queries. In this Weekly Iteration thoughtbot CTO Joe Ferris takes us on a tour of how to work with Postgres to understand and optimize the structure of our database and queries to clean up the last mile of database interaction performance concerns.
This is a companion discussion topic for the original entry at https://upcase-production.herokuapp.com/upcase/videos/optimizing-sql-queries-in-postgres