CDN$ 64.86
In Stock.
Ships from and sold by Gift-wrap available.
PostgreSQL 9.0 High Perfo... has been added to your Cart
Have one to sell?
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 – Oct 20 2010

5.0 out of 5 stars 1 customer review

See all 2 formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
"Please retry"
CDN$ 64.86
CDN$ 56.72 CDN$ 66.10

Harry Potter and the Cursed Child
click to open popover

Special Offers and Product Promotions

  • You'll save an extra 5% on Books purchased from, now through July 29th. No code necessary, discount applied at checkout. Here's how (restrictions apply)

Frequently Bought Together

  • PostgreSQL 9.0 High Performance
  • +
  • PostgreSQL: Up and Running: A Practical Introduction to the Advanced Open Source Database
Total price: CDN$ 102.50
Buy the selected items together

No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

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

Product Details

  • Paperback: 468 pages
  • Publisher: Packt Publishing (Oct. 20 2010)
  • Language: English
  • ISBN-10: 184951030X
  • ISBN-13: 978-1849510301
  • Product Dimensions: 19 x 2.7 x 23.5 cm
  • Shipping Weight: 993 g
  • Average Customer Review: 5.0 out of 5 stars 1 customer review
  • Amazon Bestsellers Rank: #177,158 in Books (See Top 100 in Books)
  •  Would you like to update product info, give feedback on images, or tell us about a lower price?

Product Description

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

5.0 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See the customer review
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback Verified Purchase
I found this book very useful for furthering my understanding of Postgres beyond what I needed to improve my application's performance. I was impressed by the clarity in the author's explanations of technical detail. He references his years of experience to emphasize what is important to consider in different database workloads, and does an excellent job expressing the value and impact different decisions have (Why you may increase or decrease this configuration value, impacts of an index, etc.). I am certain I will be referencing this book again with every project I start in the near future.

If desired, you can read just the sections you think you need to know (maintenance, indexes, high performance queries), but it isn't a long or difficult read. If you work with Postgres, and don't currently know what tuple refers to in that context, I highly encourage you to read the entire book. Full disclosure: I strongly advocate having an understanding of the layers of abstraction beneath your project, even if you do not interface with them directly.
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

Most Helpful Customer Reviews on (beta) HASH(0xa497609c) out of 5 stars 13 reviews
29 of 29 people found the following review helpful
HASH(0xa4978db0) out of 5 stars This book makes me wish I had a time machine Nov. 3 2010
By Isaac D. Reuben - Published on
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.
24 of 24 people found the following review helpful
HASH(0xa48f6e7c) out of 5 stars Get the best performance out of your hardware and PostgreSQL Dec 30 2010
By Leo Hsu - Published on
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.
13 of 13 people found the following review helpful
HASH(0xa48ef7d4) out of 5 stars Excellent book Dec 19 2010
By Mladen Gogala - Published on
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.
5 of 5 people found the following review helpful
HASH(0xa4ba6ce4) out of 5 stars great book March 9 2012
By Amazon Customer - Published on
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.
4 of 4 people found the following review helpful
HASH(0xa48eeca8) out of 5 stars Will make you understand, not just use PostgreSQL June 12 2015
By Bartosz Bilicki - Published on
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.