The PostgreSQL optimizer: What it really does
Hans-Jürgen Schönig has been a PostgreSQL expert and database specialist since the 90s. He is CEO and technical lead of CYBERTEC, which is one of the database market leaders worldwide and has served countless customers around the globe since the year 2000.As CEO of CYBERTEC, Hans-Jürgen Schönig regularly advises customers in database services and creates individual concepts tailored to each client’s needs. Additionally, he regularly gives training on PostgreSQL Advanced Optimization & Performance Tuning, PostgreSQL for Business Intelligence and Mass Data Analysis, PostgreSQL Replication Professional and Linux for PostgreSQL DBAs - just to name a few.
No video of the event yet, sorry!
What does the query optimizer really do? Is it magic? Is it Voodoo? What is really going on there? And what does all this "cost thing" really mean? Well, let us dive into the optimizer and find out, what is really going on deep inside the planner. You will be guides through the basic optimization and learn how the optimizer calculates costs, prunes joins, handles parallel queries, flattens subselects and how it treats genetic optimization as well as stored procedures and a lot more. This talk is an in-depth guide to what is really going on behind the scenes. The us uncover the secrets of the hidden biest: The PostgreSQL optimizer.
- 2019 September 19 12:00 PDT
- 50 min
- Winchester (1)
- Silicon Valley 2019