PostgreSQL 9.0 High Performance and over one million other books are available for Amazon Kindle. Learn more
Qty:1
  • List Price: $49.99
  • Save: $5.00 (10%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
PostgreSQL 9.0 High Perfo... has been added to your Cart
+ $3.99 shipping
Used: Good | Details
Condition: Used: Good
Comment: Clean, tight copy with moderate wear to covers, Ships from USA, 30-day return for any reason, Proceeds support the San Francisco Public Library.
Sell yours for a Gift Card
We'll buy it for $20.34
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 $33.24

Spring Books
The Big Books of Spring
See our editors' picks for the books you'll want to read this season, from blockbusters and biographies to new fiction and children's books.
$44.99 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.


Frequently Bought Together

PostgreSQL 9.0 High Performance + PostgreSQL 9 Admin Cookbook + PostgreSQL Server Programming
Price for all three: $139.97

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.


Best Books of the Month
Best Books of the Month
Want to know our Editors' picks for the best books of the month? Browse Best Books of the Month, featuring our favorite new books in more than a dozen categories.

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: #136,695 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

Customer Reviews

4.6 out of 5 stars
5 star
67%
4 star
22%
3 star
11%
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

25 of 25 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: Kindle Edition
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.
My server was strong but my PostgreSQL was weakly configured to only use a tiny portion of the available memory.
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

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.

What Other Items Do Customers Buy After Viewing This Item?

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
PostgreSQL 9.0 High Performance
This item: PostgreSQL 9.0 High Performance
Price: $49.99 $44.99
Ships from and sold by Amazon.com