Главная
Study mode:
on
1
Intro
2
pg_stat_statements / analyzing performance
3
Query Performance Insights / on Azure
4
Performance Recommendations / on Azure
5
Logs on Postgres / are they useful?
6
Loops, once upon a thousand times
7
CATCHING LOOPS ON PROD
8
Limiting what you are selecting
9
Pagination / why is paginating so important?
10
Pagination / Default paginator class
11
Keyset pagination / why you should care
12
Fixing a slow query / Looking into EXPLAIN
13
Fixing a slow query / adding a partial index
14
Fixing a slow query / scaling UP your server
15
Your 8 takeaways, the Postgres superpowers
Description:
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

PyCon US
Add to list
0:00 / 0:00