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.
PostgreSQL for Data Architects
By :
PostgreSQL for Data Architects
By:
Overview of this book
Table of Contents (19 chapters)
PostgreSQL for Data Architects
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Installing PostgreSQL
Server Architecture
PostgreSQL – Object Hierarchy and Roles
Working with Transactions
Data Modeling with SQL Power Architect
Client Tools
SQL Tuning
Server Tuning
Tools to Move Data in and out of PostgreSQL
Scaling, Replication, and Backup and Recovery
PostgreSQL – Troubleshooting
PostgreSQL – Extras
Index
Customer Reviews