Aivars Kalvāns: EXPLAIN: make it make sense

Most developers know how to measure the time a database query takes and to find which one is the slowest. But what next? What is going on there? Is it good that it’s doing that? Is the query supposed to take this much time? Will some indexes help? In this talk, I will help you decipher database query plans and give some rules of thumb to understand if the database is doing the best it can. We will also use query plans to find the best indexes for queries by observing what the database is looking for. I will also share several anti-patterns I have seen in projects and show how to rewrite them in a database-friendly way. Although I will use Python to explain the principles and execute my queries, I will show the raw SQL to make it applicable to any programming language.

Laurenz Albe: Don't do that!
▶︎

Laurenz Albe: Don't do that!

Gleb Otochkin: Vector data in Postgres: Size, TOAST, Filters and Performance
▶︎

Gleb Otochkin: Vector data in Postgres: Size, TOAST, Filters and Performance

Postgres vs MySQL Transactions + Log-based writes (Database Internals Chapter 5)
▶︎

Postgres vs MySQL Transactions + Log-based writes (Database Internals Chapter 5)

AI has hacked the code of human civilization | Yuval Noah Harari
▶︎

AI has hacked the code of human civilization | Yuval Noah Harari

🚀 Python Project Template – Jan Lukany, Datamole
▶︎

🚀 Python Project Template – Jan Lukany, Datamole

Creator of C++: Bell Labs, Negative Overhead Abstraction, Mistakes | Bjarne Stroustrup
▶︎

Creator of C++: Bell Labs, Negative Overhead Abstraction, Mistakes | Bjarne Stroustrup

Turing Award Winner: Disagreeing with Google, Postgres, Future Problems | Mike Stonebraker
▶︎

Turing Award Winner: Disagreeing with Google, Postgres, Future Problems | Mike Stonebraker

Josef Machytka: Database in Distress: Testing and Repairing Different Types of Database Corruption
▶︎

Josef Machytka: Database in Distress: Testing and Repairing Different Types of Database Corruption

Keynote: After the AI Hype – What’s Real, and What’s Next - Richard Campbell - 2026
▶︎

Keynote: After the AI Hype – What’s Real, and What’s Next - Richard Campbell - 2026

Joaquim Oliveira: From Stars to Storage Engines: Migrating Big Science Workloads Beyond Greenplum
▶︎

Joaquim Oliveira: From Stars to Storage Engines: Migrating Big Science Workloads Beyond Greenplum

Roberto Mello: Boosting Typical Query Patterns: PostgreSQL 18's Performance Enhancements
▶︎

Roberto Mello: Boosting Typical Query Patterns: PostgreSQL 18's Performance Enhancements

Ahmet Gedemenli, Esther Miñano Sanz: Anonymizing Data in Postgres Without Losing Your Mind (or Your
▶︎

Ahmet Gedemenli, Esther Miñano Sanz: Anonymizing Data in Postgres Without Losing Your Mind (or Your

Nelson Calero: Practical Guide to Migrating +100 Large PostgreSQL to the Cloud
▶︎

Nelson Calero: Practical Guide to Migrating +100 Large PostgreSQL to the Cloud

[Sponsor Track] Torsten Steinbach: From Transactions to Intelligence: Postgres for Open AI & Analyti
▶︎

[Sponsor Track] Torsten Steinbach: From Transactions to Intelligence: Postgres for Open AI & Analyti

Alastair Turner: Kubernetes from the Database Out
▶︎

Alastair Turner: Kubernetes from the Database Out

System Design Explained: APIs, Databases, Caching, CDNs, Load Balancing & Production Infra
▶︎

System Design Explained: APIs, Databases, Caching, CDNs, Load Balancing & Production Infra

Wait... PostgreSQL can do WHAT?
▶︎

Wait... PostgreSQL can do WHAT?

ASP.NET Core Full Course For Beginners (.NET 10)
▶︎

ASP.NET Core Full Course For Beginners (.NET 10)

System Design Explained: APIs, Databases, Caching, CDNs, Load Balancing & Production Infra
▶︎

System Design Explained: APIs, Databases, Caching, CDNs, Load Balancing & Production Infra

Fun with UUIDs - Chris Ellis
▶︎

Fun with UUIDs - Chris Ellis