Optimizing queries in PostgreSQL

It is time for us to have a talk about the elephant in the room: PostgreSQL. In this session, we will be addressing on how PostgreSQL plans and execute queries and how can we use this knowledge to optimize our queries and more importantly, make our application perform fast and reliably.