PostgreSQL Beyond Django: Strategies to Get Max Performance - DjangoCon US 2024

This conference talk from DjangoCon US 2024 explores advanced PostgreSQL optimization techniques that go beyond Django's standard functionality. Learn how to maximize database performance and reduce space usage through sophisticated strategies that extend past basic modeling and indexing. Discover powerful features including triggers, bulk data import/export methods, and proper implementation of PostgreSQL's full-text search capabilities. Follow along as Álvaro Justen demonstrates these concepts using a simple Django application specifically created for this presentation, working with a massive dataset of over 52 million rows. Gain insights into identifying and resolving issues caused by inadequate data modeling, understanding query execution, and implementing proper indexing strategies. Perfect for developers looking to efficiently handle millions of records while reducing infrastructure costs.