To get the free app, enter your email address or mobile phone number.
PostgreSQL 9.0 High Performance Paperback – October 20, 2010
|New from||Used from|
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more
Frequently Bought Together
Customers Who Bought This Item Also Bought
This book is well written and very accurate, from what I can tell, a tribute both to the author and the highly competent reviewers. I doubt there is a single PostgreSQL user or developer who could not learn something useful from this book. --Andrew Dunstan
From the Back Cover
This book is aimed at intermediate to advanced database administrators using or planning to use PostgreSQL. Portions will also interest systems administrators looking to build or monitor a PostgreSQL installation, as well as developers interested in advanced database internals that impact application design.
What you will learn from this book
- Learn best practices culled from years of work scaling PostgreSQL installations to handle demanding applications
- Uncover what makes hardware good or bad for high-performance database applications
- Investigate making informed speed and reliability trade-offs
- Tweak your operating system for best database performance
- Benchmark your whole system from hardware to application
- Follow real examnples to learn how the server parameters operate and how they impact performance
- Monitor what happens on your server, both in and outside of the database
- Find the best add-on tools that extend to core PostgreSQL database
- Discover how to architect replicated systems using the latest features added to PostgreSQL 9.0
More About the Author
Top Customer Reviews
What surprised me most about this book was how much of it is not specific to PostgreSQL, but in fact hardware considerations and testing that are pertinent to most relational databases. In that sense I wouldn't limit my recommendation to just PostgreSQL, but also to anyone using a relational database on Unix/Linux for a high load project.
The PostgreSQL 9 High Performance book isn't going to teach you too much about writing better queries,day to day management (which is more of the focus of the Admin Book), or how to load data etc, but it will tell you how to determine when your database is under stress or your hardware is failing and adversely affecting your queries and what is causing that stress. It will also provide rules of thumb as to how to pick the best hardware for your project and budget, how to partition your data, what disks to put what kind of data. Various tuning and benchmarking techniques for highload testing.
Provides a lot of details that help to actually understand what is going on in database. Every performance/optimization technique, configuration flag is explained in detail.
First half of the book covers thinks like choosing hardware, processor, memory, disk, file system, RAID matrix ,etc. In spite of the fact that I am java programmer, not DB engineer I find this part interesting too; it is good to know how database does its job.
Somewhat old (addresses postgreSQL 9.0 and older versions, we have 9.4 now), but I see no parts that are outdated. PostgreSQL have not changed that much (you may read release notes for 9.1-9.4) and basic principles (that are explained very well, in length and in great detail) are not to change anytime soon.
Speaking as a newcomer wih no DBA experience, from simple SQL to more advanced DBA concepts, this certainly gave me the background I needed to get going; it would seem, a lot of material left over to master.
Most Recent Customer Reviews
This is a nice introduction to the topic. A practical guide, with clear explanations. I have both the print and Kindle versions.Published 22 months ago by JacquesH
Ignorance is not bliss when it comes to PostgreSQL.
This book helped me with the performance issues I had, plus ones I did not even know about. Read more
Well written and comprehensive, it clearly explains important under-the-hood principles. Useful for every good programmer using and configuring Postgresql. I recommendPublished on February 3, 2014 by Davor