Sponsor Workshop: Louise Grandjonc - Optimize Python & Django apps with Postgres superpowers

Building Django apps that perform well & scale can be a challenge. In this video, you will learn Postgres superpowers to help optimize performance of Python and Django apps, using a sample Django application which runs on Azure Database for PostgreSQL.

This talk walks through how to tackle the most common pain point: slow queries. You’ll dive into the Django ORM to identify performance bottlenecks, and we’ll analyze both Python and SQL code. We’ll explore the usefulness of pg_stat_statements, django-debug-toolbar, Postgres logs, keyset pagination—as well as Query Performance Insight and Performance Recommendations on Azure. You’ll learn how to eradicate loops in your code (this is important); how to limit what you select; and how to scale out Postgres horizontally using Hyperscale (Citus) on Azure Database for PostgreSQL, in a way that is transparent to your app and does not require any re-architecture.

Just like chocolate and peanut butter go better together, so do Python and Postgres. These Postgres optimization techniques (what I call “superpowers”) will empower you to improve the performance of your Python and Django apps. (Also featuring fish I hand-painted many years ago, before I became a Django and Postgres developer.)

#Python #PostgreSQL #Django

✅ More demos, workshops, and labs from our PyCon 2020 team:

✅ Hyperscale (Citus) Quickstart Docs:

✅ GitHub repo for Citus open source extension to Postgres:

✅ Slides for this PyCon talk on Optimizing your Django & Python apps with Postgres superpowers:

✅ Talk on Debugging, “When it all goes Wrong (with Postgres)”

✅ Louise Grandjonc’s DjangoCon talk on Postgres Index Types:

✅ GitHub repo for Django Ad Application used in this video:

✅ Join Citus monthly technical newsletter, made with love by the Postgres team at Microsoft: