Postgresql 9.0 High Performance - Smith_ Gregory.pdf - Postgresql 9.0 High Performance (3106) - superktos86

PostgreSQL 9.0

High Performance

Accelerate your PostgreSQL system and avoid the

common pitfalls that can slow it down

Gregory Smith

BIRMINGHAM - MUMBAI

PostgreSQL 9.0 High Performance

system, or transmitted in any form or by any means, without the prior written

permission of the publisher, except in the case of brief quotations embedded in

critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy

of the information presented. However, the information contained in this book is

sold without warranty, either express or implied. Neither the author, nor Packt

Publishing, and its dealers and distributors will be held liable for any damages

caused or alleged to be caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the

companies and products mentioned in this book by the appropriate use of capitals.

However, Packt Publishing cannot guarantee the accuracy of this information.

First published: October 2010

Production Reference: 1141010

Published by Packt Publishing Ltd.

32 Lincoln Road

Olton

Birmingham, B27 6PA, UK.

ISBN 978-1-849510-30-1

www.packtpub.com

Cover Image by Asher Wishkerman ( a.wishkerman@mpic.de )

Credits

Author

Gregory Smith

Editorial Team Leader

Mithun Sehgal

Reviewers

Kevin Grittner

Project Team Leader

Lata Basantani

Jim Mlodgenski

Scott Marlowe

Project Coordinator

Srimoyee Ghoshal

Acquisition Editor

Sarah Cullington

Proofreader

Aaron Nash

Development Editors

Hyacintha D'Souza

Production Coordinator

Aparna Bhagat

Mayuri Kokate

Cover Work

Aparna Bhagat

Technical Editors

Sakina Kaydawala

Alfred John

Indexer

Hemangini Bari

Tejal Daruwale

About the Author

Gregory Smith is a Principal Consultant for international database professional

services irm 2ndQuadrant, and founder of the company's irst United States ofice.

Writing about PostgreSQL represents his second foray into teaching database

performance tuning. Greg wrote a small, free e-book titled Progress Performance FAQ

in 1995, covering the basics of how to make the Progress 4GL and its associated

database run faster. In 2001, he converted exclusively to using PostgreSQL 7.0 for

projects, and has been watching the complexity of problems the database is capable

of solving increase with every release since.

Greg has contributed feature additions to every PostgreSQL version since 8.3. He's

also the creator of a growing set of add-on tools for the database, currently including

pgtune, pgbench-tools, peg, and 2warm.

I was able to focus on the material in this book well enough to do

it justice only through the support provided by Simon Riggs and

the rest of the 2ndQuadrant staff around the world. The exposure

to interesting problems to solve, and resources to solve them, has

made working with 2ndQuadrant staff and clients a fertile source for

PostgreSQL performance ideas over the last year.

The writing schedule pace needed to deliver a current book covering

a major new database release just after it ships is grueling. I'd never

have made it through so many weeks of working all seven days

without the support of my family: Judy, Jerry, and Amanda.

Finally, the material in this book only exists because of the hundreds

of contributors to the PostgreSQL project. And without the free

sharing of ideas on mailing lists like pgsql-performance and pgsql-

hackers the last few years, I'd never have been able to collect up

such a wide survey of common performance issues. Whether it was

having my own questions answered, or carefully considering how to

answer someone else's, the interaction on those mailing lists has been

vital to forming the ideas of this book.

Postgresql 9.0 High Performance - Smith_ Gregory.pdf

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: