Brazilian Software Engineer with 7 years of experience, who has built several apps, working from their conception, through planning, to the implementation itself. Currently focused on Elixir and its ecosystem, building backend services to power Fresha’s applications.
A deep-dive into some of the Postgres internals and features focusing on speeding up queries. Using Ecto for practical examples and other visualizations, the aim is to provide a clear understanding of how to analyze, identify issues and finally optimize your queries. We’ll also dabble into the details of how indexes lookups, lateral joins and other features of Postgres work to help fixate the knowledge.