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.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
PostgreSQL 9.0 High Perfo... has been added to your Cart
Condition: Used: Very Good
Comment: OVERNIGHT and 2-DAY SHIPPING AVAILABLE........Very Good condition with light wear. The item is in Amazon's warehouse ready to be shipped to you. You have the assurance that you will get your item in a timely manner. In the unlikely event something should go wrong with the shipping, you can contact Amazon to assist with the customer service, tracking or hassle-free return. We are very proud to be in this program as it allows us to offer the best customer experience possible.
Trade in your item
Get a $5.36
Gift Card.
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 3 images

PostgreSQL 9.0 High Performance Paperback – October 20, 2010

4.7 out of 5 stars 13 customer reviews

See all 2 formats and editions Hide other formats and editions
Price
New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$49.99
$42.72 $23.36

The Numberlys Best Books of the Year So Far
$49.99 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Frequently Bought Together

  • PostgreSQL 9.0 High Performance
  • +
  • PostgreSQL 9 High Availability Cookbook
  • +
  • PostgreSQL 9 Administration Cookbook - Second Edition
Total price: $154.97
Buy the selected items together


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
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.)
  • Thousands of books are eligible, including current and former best sellers.
  • Look for the Kindle MatchBook icon on print and Kindle book detail pages of qualifying books. You can also see more Kindle MatchBook titles here or look up all of your Kindle MatchBook titles here.
  • Read the Kindle edition on any Kindle device or with a free Kindle Reading App.
  • Print edition must be purchased new and sold by Amazon.com.
  • Gifting of the Kindle edition at the Kindle MatchBook price is not available.
Learn more about Kindle MatchBook.


The latest book club pick from Oprah
"The Underground Railroad" by Colson Whitehead is a magnificent novel chronicling a young slave's adventures as she makes a desperate bid for freedom in the antebellum South. See 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.7 out of 5 stars  See all reviews (13 customer reviews)
  • Amazon Best Sellers Rank: #185,916 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

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 29 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 24 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 13 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Kindle Edition Verified Purchase
Excellent book. Very well written and pleasant to read.
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.
Comment 4 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Kindle Edition Verified Purchase
I picked up this text in a previous role in order to complete certain tasks that had me working with a PG database.

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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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.
Sorry, we failed to record your vote. Please try again
Report abuse

Set up an Amazon Giveaway

PostgreSQL 9.0 High Performance
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway
This item: PostgreSQL 9.0 High Performance