PostgreSQL for Data Architects: Discover how to design develop and maintain your database application effectively with PostgreSQL

PostgreSQL for Data Architects: Discover how to design, develop, and maintain your database application effectively with PostgreSQL Jayadevan Maymala
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’s advanced features will save you work and increase performance, once you’ve discovered how to set it up. PostgreSQL for Data Architects 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. Finally, you will get acquainted with useful tools available in the PostgreSQL ecosystem used for analyzing PostgreSQL logs, setting up load balancing, and recovery. Categories:
Computers – Databases
Year:
2015
Publisher:
Packt Publishing
Language:
english
Pages:
272
ISBN 10:
1783288604
ISBN 13:
9781783288601
File:
187 MB