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 email address or mobile phone number.

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: Very Good | Details
Sold by Kuycorp
Condition: Used: Very Good
Comment: Used Book , in very Good condition with minor wears on the cover. Clean pages with no markings.
Sell yours for a Gift Card
We'll buy it for $21.01
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 3 images

PostgreSQL 9.0 High Performance Paperback – October 20, 2010

4.7 out of 5 stars 12 customer reviews

See all 2 formats and editions Hide other formats and editions
Price
New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$44.99
$44.99 $40.97

Top 20 lists in Books
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
$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 9 High Availability Cookbook
Total price: $139.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 84%). Print edition purchase must be sold by Amazon. Learn more.


Image
Looking for the Audiobook Edition?
Tell us that you'd like this title to be produced as an audiobook, and we'll alert our colleagues at Audible.com. If you are the author or rights holder, let Audible help you produce the audiobook: Learn more at ACX.com.

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 (12 customer reviews)
  • Amazon Best Sellers Rank: #515,417 in Books (See Top 100 in Books)

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

Top Customer Reviews

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 of 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 of 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 of 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: 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 of 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
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 3 of 3 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

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: $44.99
Ships from and sold by Amazon.com

What Other Items Do Customers Buy After Viewing This Item?

Want to discover more products? Check out this page to see more: rhel 7