Optimizing Queries for Good Performance
In Chapter 5, Log Files and System Statistics, you learned how to read system statistics and how to make use of what PostgreSQL provides. Now that we’re armed with this knowledge, this chapter is all about good query performance. Everybody is looking for good query performance. Therefore, it’s important to address this topic in depth.
In this chapter, you’ll learn about the following topics:
- Learning what the PostgreSQL optimizer does
- Understanding execution plans
- Understanding and fixing joins
- Enabling and disabling optimizer settings
- Partitioning data
- Adjusting parameters for good query performance
- Making use of parallel queries
- Introducing just-in-time (JIT) compilation
By the end of this chapter, we’ll be able to write better and faster queries. If the queries still aren’t very good, we should be able to understand why this is the case. We’ll also be...
