The PostgreSQL optimizer: What it really does
Hans-Jürgen Schönig has been in professional PostgreSQL for over 17 years now and has dealt with customers around the globe. His company Cybertec Schönig & Schönig GmbH offers professional services for PostgreSQL, which includes training, 24x7 support, as well as consulting.
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
- 50 min
- Winchester (1)
- Silicon Valley 2019