Learn how to detect bottlenecks and make sure your database systems offer superior performance to your end users Replicate your databases to achieve full redundancy and create backups quickly and easily Optimize PostgreSQL configuration parameters and turn your database server into a high-performance machine capable of fulfilling your needs If you are a database administrator who needs to get to grips with PostgreSQL quickly and efficiently, then this book is for you. This book will also be highly beneficial if you are a project leader or a developer who is interested in knowing more about database systems or bottleneck detection, as it will enable you to work more closely and cooperatively with your administrators.
A comprehensive series of dependable recipes to design, build, and implement a PostgreSQL server architecture free of common pitfalls that can operate for years to come. Each chapter is packed with instructions and examples to simplify even highly complex database operations. If you are a PostgreSQL DBA working on Linux systems who want a database that never gives up, this book is for you. If you've ever experienced a database outage, restored from a backup, spent hours trying to repair a malfunctioning cluster, or simply want to guarantee system stability, this book is definitely for you.
"PostgreSQL Server Programming" is for moderate to advanced PostgreSQL database professionals. To get the best understanding of this book, you should have general experience in writing SQL, a basic idea of query tuning, and some coding experience in a language of your choice. . Understand the extension framework of PostgreSQL, and leverage it in ways that you haven't even invented yet . Write functions, create your own data types, all in your favourite programming language . Step-by-step tutorial with plenty of tips and tricks to kick-start server programming