PostgreSQL for Data Architects

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.

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.