"How to optimize Postgres queries for Python developers" - Lukas Fittl (Nbpy2024)
Lukas Fittl
https://pretalx.northbaypython.org/nb...
Many Python applications use Postgres as their backing database - and that means, when we think about our application performance, we have to think about the database. In this talk we'll do a dive into best practices for optimizing Postgres queries, aimed at application developers.
Starting with EXPLAIN ANALYZE (which shows you a Postgres query plan), we'll walk through common situations like how to debug a bad query plan by looking at row estimates, understanding JOIN order, the role of indexes (and which index types exist in Postgres) and how we can understand how much data is being loaded by the database behind the scenes.
Whether you work with Postgres day to day, or only think about it when there is a slow query problem in your Python application, this will help you have a more productive relationship with the database. And even if you use a different database, a lot of the principles of debugging apply universally.
Produced by NDV: / @nextdayvideo
Sat Jun 29 11:25:00 2024 at Reis River Ranch
In questa pagina del sito puoi guardare il video online "How to optimize Postgres queries for Python developers" - Lukas Fittl (Nbpy2024) della durata di ore minuti seconda in buona qualità , che l'utente ha caricato North Bay Python 02 luglio 2024, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 441 volte e gli è piaciuto 11 spettatori. Buona visione!
