PostgreSQL 9.0 High Performance and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.

Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Start reading PostgreSQL 9.0 High Performance on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

PostgreSQL 9.0 High Performance [Paperback]

Gregory Smith

Price: CDN$ 54.59 & FREE Shipping. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Usually ships within 3 to 5 weeks.
Ships from and sold by Gift-wrap available.


Amazon Price New from Used from
Kindle Edition CDN $16.49  
Paperback CDN $54.59  

Book Description

Oct. 18 2010

Accelerate your PostgreSQL system

  • Learn the right techniques to obtain optimal PostgreSQL database performance, from initial design to routine maintenance.
  • Discover the techniques used to scale successful database installations.
  • Avoid the common pitfalls that can slow your system down.
  • Filled with advice about what you should be doing; how to build experimental databases to explore performance topics, and then move what you've learned into a production database environment.
  • Covers versions 8.1 through 9.0.

In Detail

PostgreSQL database servers have a common set of problems they encounter as their usage gets heavier and requirements more demanding. You could spend years discovering solutions to them all, step by step as you encounter them. Or you can just look in here.

All successful database applications are destined to eventually run into issues scaling up their performance. Peek into the future of your PostgreSQL database's problems today. Know the warning signs to look for, and how to avoid the most common issues before they even happen.

Surprisingly, most PostgreSQL database applications evolve in the same way: Choose the right hardware. Tune the operating system and server memory use. Optimize queries against the database, with the right indexes. Monitor every layer, from hardware to queries, using some tools that are inside PostgreSQL and others that are external.

Using monitoring insight, continuously rework the design and configuration. On reaching the limits of a single server, break things up; connection pooling, caching, partitioning, and replication can all help handle increasing database workloads.

The path to a high performance database system isn't always easy. But it doesn't have to be mysterious with the right guide.

A clear, step-by-step guide to optimizing and scaling up PostgreSQL database servers

What you will learn from this book

  • How to implement PostgreSQL features for reliability and performance
  • How to use the latest PostgreSQL 9.0 features
  • Summaries to help DBAs with experience of other database systems
  • Advanced technical tips and scripts for experienced users
  • Best practice for planning and designing live databases.
  • How and when to VACUUM your databases.
  • Selecting and implementing robust backup techniques.
  • Concise and clear guidance on replication and high availability.


Written in the cookbook style, this book offers learning and techniques through recipes. It contains step-by-step instructions for administrators and developers to manage databases on PostgreSQL. The book is designed in such a way that you can read it chapter by chapter or refer to recipes in no particular order.

Who this book is written for

This book is for Sysadmins, Database Administrators, Architects, Developers, and anyone with an interest in planning for or running live production databases. This book is most suited to those who have some technical experience.

Frequently Bought Together

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

Customers Who Bought This Item Also Bought

Product Details

  • Paperback: 1 pages
  • Publisher: Packt Publishing (Oct. 18 2010)
  • Language: English
  • ISBN-10: 184951030X
  • ISBN-13: 978-1849510301
  • Product Dimensions: 23.5 x 19 x 2.4 cm
  • Shipping Weight: 980 g
  • Amazon Bestsellers Rank: #150,637 in Books (See Top 100 in Books)

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

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on (beta) 4.6 out of 5 stars  8 reviews
22 of 22 people found the following review helpful
5.0 out of 5 stars This book makes me wish I had a time machine Nov. 3 2010
By Isaac D. Reuben - Published on
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.
18 of 18 people found the following review helpful
5.0 out of 5 stars Get the best performance out of your hardware and PostgreSQL Dec 30 2010
By Leo Hsu - Published on
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.
9 of 9 people found the following review helpful
5.0 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.
3 of 3 people found the following review helpful
4.0 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.
5.0 out of 5 stars Goto basic guide for PostgreSQL performance April 12 2014
By JacquesH - Published on
Format:Paperback|Verified Purchase
This is a nice introduction to the topic. A practical guide, with clear explanations. I have both the print and Kindle versions.

Look for similar items by category