Speeding Up Queries with Ecto and Postgres

Filipe Fróes, a software engineer at Freshia, presents on how to improve query performance when working with massive amounts of data using Ecto and Postgres. Filipe shares practical tips and techniques, including understanding and utilizing query plans, effective indexing, and avoiding common pitfalls like the N+1 problem. He delves into the importance of the order of columns in indices and the benefits of including values in indices to avoid additional database fetches. Filipe also explains how to make the most of Ecto's preloading features and lateral joins to optimize database queries. Throughout the talk, he emphasizes the importance of understanding your data model and use cases to apply these techniques effectively.