About this session
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
Presented by
-
Álvaro Justen
Álvaro Justen, also known as @turicas, is a Brazilian programmer, teacher, and entrepreneur. Started programming at age of 14 and been working with Python since 2005. Founder of Brasil.IO, a platform for accessible open data, he is an activist for free/libre software and open data and has organized important events in local communities, such as PythonBrasil8 (Rio de Janeiro, Brazil, 2012) and PythonQuito (Ecuador, 2016), also volunteered as the coordinator for collecting the open Brazilian COVID-19 dataset in 2020/21, at a time when the Federal Government was hiding data.
Álvaro is the founder and technical leader of PythonicCafé, a company that develops various projects for capturing and analyzing open data in Brazil, and teaches in the master's program for data journalism at Insper (São Paulo, Brazil). When not programming or teaching, he enjoys traveling, tasting, and roasting specialty coffees.
