DjangoCon US 2024: PostgreSQL Beyond Django: Strategies to Get Max Performance with Álvaro Justen
0PostgreSQL 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/postg...
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
https://confreaks.bsky.social/