PostgreSQL 9.0 High Performance and over one million other books are available for Amazon Kindle. Learn more
Buy New
$44.99
Qty:1
  • List Price: $49.99
  • Save: $5.00 (10%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Sell yours for a Gift Card
We'll buy it for $19.26
Learn More
Trade in now
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

PostgreSQL 9.0 High Performance Paperback – October 20, 2010


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$44.99
$41.00 $40.10
Best%20Books%20of%202014


Frequently Bought Together

PostgreSQL 9.0 High Performance + PostgreSQL 9 Admin Cookbook + PostgreSQL: Up and Running
Price for all three: $106.75

Buy the selected items together
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 84%). Print edition purchase must be sold by Amazon. Learn more.


Hero Quick Promo
12 Days of Kindle Book Deals
Load your library with Amazon's editors' picks, $2.99 or less each today only. Learn more

Product Details

  • Paperback: 468 pages
  • Publisher: Packt Publishing (October 20, 2010)
  • Language: English
  • ISBN-10: 184951030X
  • ISBN-13: 978-1849510301
  • Product Dimensions: 7.5 x 1.1 x 9.2 inches
  • Shipping Weight: 2.2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon Best Sellers Rank: #156,111 in Books (See Top 100 in Books)

Editorial Reviews

Review

I found the book to be well-written (always a plus when reading technical books) and felt it covered quite a bit of depth given its ambitious scope. Overall, it was an informative and enjoyable read. --David Christensen

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

Who this book is written for
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

Gregory Smith is the principal consultant in the United States for international PostgreSQL services firm 2ndQuadrant. Based in Baltimore, MD, he's been providing database advice to clients in industries like manufacturing, finance, and web development for twenty years. Dedicated to open-source technology since early in his career, Greg turned to full-time PostgreSQL work by diving in at the source code level. He contributes regular feature patches to the core database and has written a variety of database tools. This book reflects the perspective that he's gained over the last few years as one of the most prolific sources of advice on the popular PostgreSQL community mailing lists.

Customer Reviews

4.6 out of 5 stars
5 star
6
4 star
2
3 star
1
2 star
0
1 star
0
See all 9 customer reviews
A practical guide, with clear explanations.
JacquesH
Greg Smith showed a real out of the box thinking and explained the influence of things like the choice of file system to the database performance.
Mladen Gogala
Useful for every good programmer using and configuring Postgresql.
Davor

Most Helpful Customer Reviews

24 of 24 people found the following review helpful By Isaac D. Reuben on November 3, 2010
Format: Paperback
I wish I could send this back in time to myself three years ago when I was first digging into Postgres, as this book contains all the hard earned nuggets I've found through scouring online discussions and email lists, plus a lot more I didn't know, and all in a very clear and readable format. It focuses a lot on explaining how Postgres works under the hood so instead of just following rules of thumb for selecting hardware or choosing configuration options, you can really understand what Postgres is doing and *why* these things affect it's performance. Highly recommended to anyone responsible for setting up and maintaining a Postgres db, developing an application that uses Postgres, or who just wants to better understand how Postgres works.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
22 of 22 people found the following review helpful By Leo Hsu on December 30, 2010
Format: Paperback
I've also read the companion PostgreSQL 9 Admin Cookbook. The Admin cookbook is an easier read, but this book had a lot more information I was unaware of and probably hit my weaker knowledge spots. There is very little overlap between the two books.

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.
2 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
12 of 12 people found the following review helpful By Mladen Gogala on December 19, 2010
Format: Paperback Verified Purchase
This is an excellent book which summarizes all the ways of improving performance of the PostgreSQL database. I have more than 20 years of database experience, mostly Oracle, and almost as much Unix and Linux experience. Greg Smith showed a real out of the box thinking and explained the influence of things like the choice of file system to the database performance. An excellent book, a must have for a DBA and anybody interested in PostgreSQL.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
4 of 4 people found the following review helpful By Amazon Customer on March 9, 2012
Format: Paperback Verified Purchase
The chapter on query optimization alone was worth the price of the book. You need this book if you want to be a postgresql guru. Chock full of info from hardware benchmarking to server tuning.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback Verified Purchase
This is a nice introduction to the topic. A practical guide, with clear explanations. I have both the print and Kindle versions.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

What Other Items Do Customers Buy After Viewing This Item?