Over 90 hands-on recipes to effectively manage, administer, and design solutions using PostgreSQL About This Book<ul>
<li>Implement a highly available PostgreSQL database server and perform administrative and development functions with PostgreSQL</li>
<li>Perform database operations in PostgreSQL using Perl and Python</li>
<li>Step-by-step recipes focusing on providing real-world Postgresql solutions</li>
</ul>Who This Book Is ForIf you are a system administrator, database administrator, architect, developer, or anyone with an interest in planning, managing, and designing database solutions using PostgreSQL, this is the book for you. This book is suited for you if you have some prior experience with any relational database or with the SQL language.What You Will Learn<ul>
<li>Perform regular maintenance tasks to keep your database steady and achieve optimal performance</li> <li>Design and implement various high availability and replication features to provide redundancy, fault tolerance, and failover</li> <li>Diagnose and troubleshoot CPU, memory, and I/O related database performance issues</li> <li>Perform database operations using languages such as Perl and Python</li> <li>Discover the different backup and recovery strategies that can be implemented in PostgreSQL</li> <li>Implement connection pooling methods to achieve load balancing</li> </ul>In DetailPostgreSQL is an open source database management system. It is used for a wide variety of development practices such as software and web design, as well as for handling large datasets (big data).
With the goal of teaching you the skills to master PostgreSQL, the book begins by giving you a glimpse of the unique features of PostgreSQL and how to utilize them to solve real-world problems. With the aid of practical examples, the book will then show you how to create and manage databases. You will learn how to secure PostgreSQL, perform administration and maintenance tasks, implement high availability features, and provide replication. The book will conclude by teaching you how to migrate information from other databases to PostgreSQL.

Postgresql Cookbook

Computers & Technology

Chauhan, Chitij

Networking & Cloud Computing

Packt Pub Ltd

Get to know effective ways to improve PostgreSQL's performance and master query optimization, and database monitoring.About This Book<ul>
<li>Perform essential database tasks such as benchmarking the database and optimizing the server's memory usage</li>
<li>Learn ways to improve query performance and optimize the PostgreSQL server</li>
<li>Explore a wide range of high availability and replication mechanisms to build robust, highly available, scalable, and fault-tolerant PostgreSQL databases</li>
</ul>Who This Book Is ForIf you are a developer or administrator with limited PostgreSQL knowledge and want to develop your skills with this great open source database, then this book is ideal for you. Learning how to enhance the database performance is always an exciting topic to everyone, and this book will show you enough ways to enhance the database performance.What You Will Learn<ul>
<li>Build replication strategies for homogeneous and heterogeneous databases</li>
<li>Test and build a powerful machine with multiple bench marking techniques</li>
<li>Get to know a few SQL injection techniques</li>
<li>Find out how to manage the replication using multiple tools</li>
<li>Benchmark the database server using multiple strategies</li>
<li>Work with the query processing algorithms and their internal behaviors</li>
<li>Build a proper plan to upgrade or migrate to PostgreSQL from other databases</li>
<li>See the essential database load balancing techniques and the various partitioning approaches PostgreSQL provides</li>
<li>Learn memory optimization techniques and database server configurations</li>
</ul>In Detail

PostgreSQL High Performance Cookbook

Kumar, Dinesh

Databases & Big Data

Packt Publishing

See the best price to sell, buy, or rent books by Chauhan, Chitij. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Chauhan, Chitij