Presented by:

B6a49c94cebe2339948e5d54dc3fa745

Hans-Jürgen Schönig

Cybertec Schönig & Schönig GmbH

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.

Date:
2019 September 19 12:00
Duration:
50 min
Room:
Winchester (1)
Conference:
Silicon Valley 2019
Language:
Track:
Dev
Difficulty:
Hard