"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
Auf dieser Seite können Sie das Online-Video "How to optimize Postgres queries for Python developers" - Lukas Fittl (Nbpy2024) mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer North Bay Python 02 Juli 2024 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 441 Mal angesehen und es wurde von 11 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
