Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
PostgreSQL 9.0 High Performance Paperback – October 20, 2010
|New from||Used from|
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
If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle edition for only $2.99 (Save 83%). Print edition purchase must be sold by Amazon. Learn more.
For thousands of qualifying books, your past, present, and future print-edition purchases now lets you buy the Kindle edition for $2.99 or less. (Textbooks available for $9.99 or less.)
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.
This book helped me with the performance issues I had, plus ones I did not even know about.
My server was strong but my PostgreSQL was weakly configured to only use a tiny portion of the available memory.
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 on April 12, 2014 by JacquesH
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