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

Who This Book Is For

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.

What You Will Learn

Perform routine backups and restore your databases safely
Set up replication quickly and easily
Handle logfiles and extract information from PostgreSQL
Monitor PostgreSQL and integrate it into the existing infrastructure
Build desktop applications using C#
Optimize PostgreSQL for high speed and tune your database parameters
Adjust your user permissions and lock out intruders
Detect bottlenecks and find missing indexes with ease

In Detail

With more than a quarter of a century of development and innovation, PostgreSQL has gained a reputation for stability, robustness, and ease of use. The variety of features available within PostgreSQL makes it a powerful tool for your professional relational database infrastructure.

With the database administrator in mind, this compact, easy-to-read, and practically-oriented book will make your daily handling of PostgreSQL more efficient and rewarding. You will learn about optimization, bottleneck detection, backup and recovery, replication, logfile management, indexing, and much more in a systematic and carefully structured manner. This invaluable guide will enable you to develop the fundamental skills required to deploy PostgreSQL in order to efficiently manage your databases.

�ber die Autorin bzw. den Autor

Hans-Jurgen Schonig and his company Cybertec Schonig & Schonig GmbH (www.postgresql-support.de) have been in professional PostgreSQL service, support, and consulting for over 15 years. He has written several books on PostgreSQL and has serviced customers around the globe. In his daily work, he focuses on performance optimization, PostgreSQL support, and training, as well as, on scalable solutions based on PostgreSQL. He likes working on complex PostgreSQL problems―especially on large-scale systems and analytical problems. When he is not visiting customers, he is based in Wiener Neustadt, Austria.

��ber diesen Titel� kann sich auf eine andere Ausgabe dieses Titels beziehen.