PostgreSQL 9.0 High Performance and over one million other books are available for Amazon Kindle. Learn more
CDN$ 61.62
  • List Price: CDN$ 63.07
  • You Save: CDN$ 1.45 (2%)
Usually ships within 2 to 4 weeks.
Ships from and sold by Amazon.ca.
Gift-wrap available.
Quantity:1
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 2 images

PostgreSQL 9.0 High Performance Paperback – Oct 18 2010


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
CDN$ 61.62
CDN$ 61.62 CDN$ 50.00

Summer Clearance on Books Books That Make You Think



Frequently Bought Together

PostgreSQL 9.0 High Performance + PostgreSQL 9 Administration Cookbook
Price For Both: CDN$ 123.24

One of these items ships sooner than the other.

Buy the selected items together



Product Details

  • Paperback: 468 pages
  • Publisher: Packt Publishing (Oct. 18 2010)
  • Language: English
  • ISBN-10: 184951030X
  • ISBN-13: 978-1849510301
  • Product Dimensions: 19 x 2.7 x 23.5 cm
  • Shipping Weight: 980 g
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: #255,252 in Books (See Top 100 in Books)

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.

Inside This Book

(Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

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

Most helpful 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. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 10 reviews
27 of 27 people found the following review helpful
This book makes me wish I had a time machine Nov. 3 2010
By Isaac D. Reuben - Published on Amazon.com
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
Get the best performance out of your hardware and PostgreSQL Dec 30 2010
By Leo Hsu - Published on Amazon.com
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
Excellent book Dec 19 2010
By Mladen Gogala - Published on Amazon.com
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
great book March 9 2012
By Amazon Customer - Published on Amazon.com
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.
Will make you understand, not just use PostgreSQL June 12 2015
By Bartosz Bilicki - Published on Amazon.com
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.


Feedback