PostgreSQL Query Optimization Techniques | Databases A2Z

Learn how the PostgreSQL query planner approaches join planning, and how it gathers and uses statistics.
Secure Node.js, Express.js and PostgreSQL API using Passport.js
☞ https://morioh.com/p/1735531bc3d6
PostgreSQL Database Administration (DBA) for Beginners
☞ https://morioh.com/p/065acd2366c1
Full-Stack React-App on AWS with PostgreSQL Database
☞ https://morioh.com/p/837ce503dc26

In this talk, I’ll talk at a high level about how the PostgreSQL query planner approaches join planning, and how it gathers and uses statistics. Without losing sight of the fact that these algorithms generally work, I want to highlight some of the annoying cases where they break down, and the problems that they can cause for users and developers.

#PostgreSQL #Database #DatabasesA2Z

PUBLICATION PERMISSIONS:
Original video was published with the Creative Commons Attribution license (reuse allowed).
Link: https://www.youtube.com/watch?v=XA3SBgcZwtE
————————————————————————————
Social Network for Developers: http://bit.ly/2M1cxD2
Developer’s Store: http://bit.ly/2L27JNR
Fanpage: http://bit.ly/2LyM4fJ