Author: simongl
There is another great book on PostgreSQL: PostgreSQL 9.0 High Performance written by Gregory Smith and published by Packt Publishing.
From the very beginning I was thinking that it would be a really great position, and I wasn’t wrong.
Chapters Review
Chapter 1: PostgreSQL Versions Some history of PostgreSQL database and just basic information about installing libraries from contrib set.
Chapter 2: Database Hardware How to choose disks, CPUs and memory for a new hardware for a database server, and what to do with RAID.
Chapter 3: Database Hardware Benchmarking Great tutorial on benchmarking all server components: CPUs, disks and memory.
Chapter 4: Disk Setup Chapter on choosing the best filesystem for database and a great PostgreSQL files on disk layout guideline.
Chapter 5: Memory for Database Chaching Really cool chapter on PostgreSQL internal memory caching and how to inspect buffer cache usage and its content.
Chapter 6: Server Configuration Tuning Quite interesting chapter on different aspects of tuning server configuration, including also description of the parameters that shouldn’t be touched.
Chapter 7: Routine Maintenance MVCC, visibility, vacuum, analyzing tables, index bloat and monitoring queries. A must read chapter for every system administrator.
Chapter 8: Database Benchmarking Really cool chapter on benchmarking using pgbench. I’d like to see there description of some other database benchmarking tools.
Chapter 9: Database Indexing Very interesting chapter about indexes maintanance.
Chapter 10: Query Optimization Another must read chapter for all admins, great amount of information on optimizing queries, including description of output of the analyze command and setting statistics.
Chapter 11: Database Activity and Statistics Chapter on checking database statistics and current database activity.
Chapter 12: Monitoring and Trending How to monitor PostgreSQL using standard Unix tools but also Nagios, Cacti and Munin.
Chapter 13: Pooling and Caching Description of standard PostgreSQL poolers: pgpool and pgBouncer.
Chapter 14: Scaling with Replication Very short description of replication solutions. This chapter could be a little longer with examples of configuration the tools.
Chapter 15: Partitioning Data Nice chapter on partitions, including nice PL/Proxy used by Skype.
Chapter 16: Avoiding Common Problems Quite a nice list of common problems and simple recipes.
Summary
I think this book is great, and I think I will read it once again, as I don’t remember everything, and this book deserves learning all by heart.
Article Source: http://www.articlesbase.com/software-articles/postgresql-90-high-performance-review-3932924.html
About the Author
