LOUISE GRANDJONC: Tips and tricks to optimize Python & Django apps with Postgres

ABOUT TALK
Much like chocolate and peanut butter, Python and Postgres belong together. In this talk, we will discuss some challenges of building performant and scalable Django applications and show how to address them using the Django ORM and Postgres.
You will learn how to configure your local Postgres logs to know what your Django app is asking from your db, read those logs, and identify performance bottlenecks and other issues. Together, we’ll analyze several code samples: loops of queries, slow individual queries and how to debug them, pagination, how to do it right, why the default Django pagination is not enough, and some others.

ABOUT SPEAKER
Louise Grandjonc is a Python and SQL developer specializing in performance and Postgres. After 2+ years at Citus (Microsoft), she is currently developing a multi platform (Azure and AWS) Postgres as a service at Crunchy Data. Louise is an active member of the Postgres and Postgres Women communities and frequent speaker at industry events.
Personal website: www.louisemeta.com