PostgreSQL for Data Architects - Softcover

Jayadevan Maymala

 
9781783288601: PostgreSQL for Data Architects
Softcover
ISBN 10: 1783288604 ISBN 13: 9781783288601
Publisher: Packt Publishing, 2015

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.

"synopsis" may belong to another edition of this title.

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.

"About this title" may belong to another edition of this title.

Publisher
Packt Publishing
Publication date
2015
Language
English
ISBN 10 
1783288604
ISBN 13 
9781783288601
Binding
Paperback
Number of pages
290