Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
PostgreSQL for Data Architects


Discover how to design, develop, and maintain your database application effectively with PostgreSQL

About This Book

  • Understand how to utilize the most frequently used PostgreSQL ecosystem-related tools and technologies
  • A hands-on guide focused primarily on providing a practical approach to learning about architecture and design considerations for database architects
  • The book covers PostgreSQL from a data architect's perspective – covering topics from installation from source to designing tables using SQL Power Architect, as well as deciding replication and failover strategies.

Who This Book Is For

This book is for developers and data architects who have some exposure to databases. It is assumed that you understand the basic concepts of tables and common database objects, including privileges and security.

What You Will Learn

  • Compile PostgreSQL from source and understand the PostgreSQL architecture
  • Configure parameters and change default settings for a PostgreSQL server
  • Leverage the logging mechanism to identify errors and suboptimal queries
  • Use replication to scale horizontally
  • Set up backup and recovery processes
  • Tweak parameters to optimize queries and processes
  • Troubleshoot connection errors
  • Use indexes and rewrite queries to improve performance
  • Install and use PostgreSQL extensions
  • Learn how to leverage the command-line client (psql)

In Detail

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.

(HTML tags aren't allowed.)

Building Microservices
Building Microservices

Distributed systems have become more fine-grained in the past 10 years, shifting from code-heavy monolithic applications to smaller, self-contained microservices. But developing these systems brings its own set of headaches. With lots of examples and practical advice, this book takes a holistic view of the topics that system...

Designing Machine Learning Systems with Python
Designing Machine Learning Systems with Python

Design efficient machine learning systems that give you more accurate results

About This Book

  • Gain an understanding of the machine learning design process
  • Optimize machine learning systems for improved accuracy
  • Understand common programming tools and techniques for machine...
QlikView Server and Publisher
QlikView Server and Publisher

Written for server administrators, this book guides you step by step through installing, managing, and maintaining QlikView Server and Publisher for your enterprise. It's the foolproof route to turning information into knowledge.


  • Learn how to install and utilize the feature-rich QlikView with...

C# 6.0 and the .NET 4.6 Framework
C# 6.0 and the .NET 4.6 Framework

This new 7th edition of Pro C# 6.0 and the .NET 4.6 Platform has been completely revised and rewritten to reflect the latest changes to the C# language specification and new advances in the .NET Framework. You'll find new chapters covering all the important new features that make .NET 4.6 the most comprehensive release yet,...

Python Parallel Programming Cookbook
Python Parallel Programming Cookbook

Master efficient parallel programming to build powerful applications using Python

About This Book

  • Design and implement efficient parallel software
  • Master new programming techniques to address and solve complex programming problems
  • Explore the world of parallel programming...
Python in Practice: Create Better Programs Using Concurrency, Libraries, and Patterns (Developer's Library)
Python in Practice: Create Better Programs Using Concurrency, Libraries, and Patterns (Developer's Library)

Winner of the 2014 Jolt Award for "Best Book"


“Whether you are an experienced programmer or are starting your career, Python in Practice is full of valuable advice and example to help you improve your craft by thinking about...

©2017 LearnIT (support@pdfchm.net) - Privacy Policy