PostgreSQL for Data Architects

Maymala, Jayadevan

ISBN 10: 1783288604 / ISBN 13: 9781783288601

Published by Packt Publishing, 2015

Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_363523751

Synopsis:

PostgreSQL is an incredibly flexible and dependable open source relational database. Harnessing its power will make your applications more reliable and extensible without increasing costs. Using PostgreSQL sadvanced features will save you work and increase performance, once you've discovered how to set it up.

This book will teach you everything you need to learn in order to get a scalable and optimized PostgreSQL server up and running.

The book starts with basic concepts like installing PostgreSQL from source and covers theoretical aspects such as concurrency and transaction management. After this, you'll learn how to set up replication, use load-balancing to scale horizontally, and troubleshoot errors.

As you continue through this book, you will see the significant impact of configuration parameters on performance, scalability, and transaction management. Finally, you will get acquainted with useful tools available in the PostgreSQL ecosystem used for analyzingPostgreSQL logs, setting up load-balancing, and recovery.

About the Author: Jayadevan Maymala is a database developer, designer and architect. He started working with Oracle database in 1999. Over the years, he has worked with DB2, Sybase and SQL Server. Of late, he has been working with open source technologies. His database of choice is PostgreSQL. In his career, he has worked in systems spanning different sectors supply chain management, finance, travel, and social networks. He has spent an equal amount of time working with databases supporting critical transaction processing systems as well as data warehouses supporting analytical systems. He has worked with clients such as General Electric and JPMorgan Chase.

When he is not working in open source technologies, he spends time reading, updating himself on economic and political issues.

Bibliographic Details

Title: PostgreSQL for Data Architects
Publisher: Packt Publishing
Publication Date: 2015
Binding: Paperback
Condition: Good