Discover Postgres superpowers to optimize Python and Django app performance in this 43-minute PyCon US workshop. Explore techniques to tackle slow queries, identify bottlenecks using Django ORM, and analyze Python and SQL code. Learn to leverage tools like pg_stat_statements, django-debug-toolbar, and Azure's Query Performance Insight. Master the art of eradicating loops, limiting selections, and implementing keyset pagination. Gain insights into scaling Postgres horizontally with Hyperscale (Citus) on Azure Database for PostgreSQL. Dive into practical examples using a sample Django application, and unlock eight key takeaways to supercharge your Python and Django projects with PostgreSQL optimization techniques.
Optimize Python & Django Apps with Postgres Superpowers
Overview
Syllabus
Intro
pg_stat_statements / analyzing performance
Query Performance Insights / on Azure
Performance Recommendations / on Azure
Logs on Postgres / are they useful?
Loops, once upon a thousand times
CATCHING LOOPS ON PROD
Limiting what you are selecting
Pagination / why is paginating so important?
Pagination / Default paginator class
Keyset pagination / why you should care
Fixing a slow query / Looking into EXPLAIN
Fixing a slow query / adding a partial index
Fixing a slow query / scaling UP your server
Your 8 takeaways, the Postgres superpowers
Taught by
PyCon US
