This book is designed to cover the problems that novice DBAs particularly struggle with. This handbook covers a minimal amount of theoretical informat
PostgreSQL for Data Architects
- Author : Jayadevan Maymala
- Year : 2015
- Pages : 272
- File size : 5.58 MB
- File format : PDF
- Category : Databases, Postgresql
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.
eBooks in the same categorie :
As a DBA you must have encountered a slow running application on SQL Server, but there are various factors that could be affecting the performance. If
PostgreSQL, often known as simply “Postgres”, is an object-relational database management system (ORDBMS) with an emphasis on extensibilit
PostgreSQL is an open source database management system. It is used for a wide variety of development practices such as software and web design, as we
PostgreSQL is an enterprise-level database that competes among proprietary database vendors, owing to its remarkable feature set and reliability witho
This book will show you that PostgreSQL is so much more than a database server. In fact, it could even be seen as an application development framework
Carry out data analysis with PySpark SQL, graphframes, and graph data processing using a problem-solution approach. This book provides solutions to pr
PostgreSQL is a powerful, open source, object-relational database system, fast becoming one of the world’s most popular server databases with an