Book Image

PostgreSQL for Data Architects

By : Jayadevan M
Book Image

PostgreSQL for Data Architects

By: Jayadevan M

Overview of this book

Table of Contents (19 chapters)
PostgreSQL for Data Architects
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Chapter 8. Server Tuning

In the previous chapter, we saw how the PostgreSQL optimizer works. We also saw how making changes to a query, creating an index, avoiding functions, and so on change the way queries are executed by PostgreSQL. These minor changes often have a significant impact on performance and response time. In this chapter, we will see the parameters that affect query performance, and how to use two special data structures: materialized views and partitions.