In this chapter, we covered the important processes and memory structures in PostgreSQL. We also saw how some configuration settings can be effectively used to capture data about the activities in the server and use it to further optimize the database performance. In the next chapter, we will look at the concepts of tablespaces, schemas, and roles. We will also look at how these are related to each other and how we can use them to take care of security and logical separation issues.

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
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