PostgreSQL Beyond Django: Strategies to Get Max Performance

PostgreSQL has been evolving in functionality and performance for decades, yet we often fail to extract full potential of the most advanced FL/OSS RDBMS. In this talk, I'll cover techniques for optimizing database performance and reducing space usage, beyond the basics of modeling and indexing and exploring powerful features such as triggers and bulk data import/export (not the Django one). If you want to handle millions of records easily and lower your infrastructure costs, this talk is for you! All the features mentioned will be presented using a simple Django app, created specifically for this talk. Topics to be covered:

Introduction of the speaker Context about the dataset used on examples (52M+ rows) Issues caused by inadequate data modeling (from wrong types to field ordering) Understanding query execution Indexing, triggers, and other tools Using postgres' full-text search the right way Importing and exporting large amounts of data with Python

This talk was presented at: https://2024.djangocon.us/talks/postgresql-beyond-django-strategies-to-get-max-performance/

LINKS: Follow Álvaro Justen 👇 On X: https://x.com/turicas Website: https://brasil.io/

Follow DjangoCon US 👇 https://fosstodon.org/@djangocon https://x.com/djangocon

Follow DEFNA 👇 https://www.defna.org/

Video production by Confreaks Follow Confreaks 👇 https://confreaks.com https://x.com/confreaks