Ahmed Ibrar - PostgreSQL 9.6 high performance: optimize, troubleshoot, and benchmark your PostgreSQL database

BIRMINGHAM - MUMBAI

Copyright 2017 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval 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 authors, 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: May 2017

Production reference: 1260517

ISBN 978-1-78439-297-0

www.packtpub.com

Ibrar Ahmed is a Senior Database System Architect in an Enterprise PostgreSQL company. Prior to coming to open source development, he had experience in software and embedded system development. He also possesses vast experience in open source development. He has contributed to the PostgreSQL community as well as other open source communities, such as the Google Chromium project. He is an open source evangelist, and his passion for open source development has enabled him to contribute a number of significant features to different open source communities.

Ibrar has contributed significantly to the goal of making PostgreSQL a federated RDBMS. He has developed, and maintains, a number of PostgreSQL extensions that communicate with other RDBMS's, such as MySQL; NoSQL databases, such as MongoDB; and parallel file system storage, such as HDFS. He has authored another book, PostgreSQL Developer's Guide, for Packt Publishing.

Gregory Smith is a Chief PostgreSQL Evangelist in Charleston, South Carolina, for Crunchy Data Solutions, Inc. He's been providing database advice to clients in industries such as manufacturing, finance, and web development for 20 years.

Writing about PostgreSQL represents his second foray into teaching database performance tuning. He 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 ever 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.

Daniel Durante is an avid coffee drinker/roaster, motorcyclist, archer, welder, and carpenter whenever he isnt programming. From the age of 12, he has been involved in web and embedded programming with PHP, Node.js, Golang, Rust, and C.

He has worked on text-based browser games that have reached over 1,000,000 active players, created bin-packing software for CNC machines, and helped contribute to one of the oldest ORMs of Node.js--SequelizeJS.

He has also reviewed PostgresSQL Developers Guide for Packt.

For support files and downloads related to your book, please visit www.PacktPub.com .

Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at www.PacktPub.com and as a print book customer, you are entitled to a discount on the eBook copy. Get in touch with us at service@packtpub.com for more details.

At www.PacktPub.com , you can also read a collection of free technical articles, sign up for a range of free newsletters and receive exclusive discounts and offers on Packt books and eBooks.

https://www.packtpub.com/mapt

Get the most in-demand software skills with Mapt. Mapt gives you full access to all Packt books and video courses, as well as industry-leading tools to help you plan your personal development and advance your career.

• Fully searchable across every book published by Packt
• Copy and paste, print, and bookmark content
• On demand and accessible via a web browser

Thanks for purchasing this Packt book. At Packt, quality is at the heart of our editorial process. To help us improve, please leave us an honest review on this book's Amazon page at https://www.amazon.com/dp/1784392979.

If you'd like to join our team of regular reviewers, you can e-mail us at customerreviews@packtpub.com. We award our regular reviewers with free eBooks and videos in exchange for their valuable feedback. Help us be relentless in improving our products!

PostgreSQL has become an increasingly viable database platform to serve as storage for applications, ranging from classic corporate database use to the latest web apps. However, getting the best performance from it has not been an easy subject to learn. You just need the right combination of rules of thumb to get started, solid monitoring and maintenance to keep your system running well, suggestions for troubleshooting, and hints for add-on tools to add the features that the core database doesn't try to handle on its own.