Summary

In this chapter, several query optimizations were discussed. You learned about the optimizer and various internal optimizations, such as constant folding, view inlining, joins, and much more. We also covered some more optimization techniques, such as JIT compilation and parallel queries. All of these optimizations contribute to good performance and help speed things up considerably.

Now that we’ve covered this introduction to optimizations, in Chapter 7, Writing Stored Procedures, we’ll talk about stored procedures. You’ll learn about all the options PostgreSQL has with which we can handle user-defined code.