Recognize and avoid these sixty common PostgreSQL mistakes!

The best mistakes to learn from are ones made by other people! In PostgreSQL Mistakes and How To Avoid Them you'll explore dozens of common PostgreSQL errors so you can easily avoid them in your own projects.

In PostgreSQL Mistakes and How To Avoid Them you'll learn how to:

• Avoid configuration and operation issues
• Maximize PostgreSQL utility and performance
• Fix bad SQL practices
• Solve common security and administration issues
• Ensure smooth migration and upgrades
• Diagnose and fix a bad database

Fixing a PostgreSQL mistake can be tricky and time-consuming, especially when you're making risky live changes to an in-use system. PostgreSQL Mistakes and How To Avoid Them helps you spot and sidestep problems in setup, admin, querying, migrating, upgrading, and more. Follow these tested best practices to ensure top performance and future-proof your database systems for seamless change and growth. Each of the 60 mistakes is carefully described and accompanied by a demo, along with an explanation that expands your knowledge of PostgreSQL internals and helps you to build a stronger mental model of how the database engine works.

About the Author

Jimmy Angelakos is a Systems and Database Architect and recognized PostgreSQL expert with a wealth of experience gained from his career in Software Architecture and key roles at 2ndQuadrant and EDB. He studied Computer Science at the University of Aberdeen and has worked with, and contributed to, Open-Source tools for 25+ years. Jimmy is a regular speaker at conferences and events focused on databases and Open-Source software, sharing his insights with the community.

Book Information
ISBN 9781633436879
Author Jimmy Angelako
Format Paperback
Page Count 232
Imprint Manning Publications
Publisher Manning Publications