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.)

Raspberry Pi for Secret Agents
Raspberry Pi for Secret Agents

Turn your Raspberry Pi into your very own secret agent toolbox with this set of exciting projects!


  • Detect an intruder on camera and set off an alarm
  • Listen in or record conversations from a distance
  • Find out what the other computers on your network are up to
  • ...
A First Course in Mathematical Modeling
A First Course in Mathematical Modeling

Offering a solid introduction to the entire modeling process, A FIRST COURSE IN MATHEMATICAL MODELING, 5th Edition delivers an excellent balance of theory and practice, and gives you relevant, hands-on experience developing and sharpening your modeling skills. Throughout, the book emphasizes key facets of modeling, including creative and...

Data Mining: The Textbook
Data Mining: The Textbook

This textbook explores the different aspects of data mining from the fundamentals to the complex data types and their applications, capturing the wide diversity of problem domains for data mining issues. It goes beyond the traditional focus on data mining problems to introduce advanced data types such as text, time series, discrete sequences,...

Essential Algorithms: A Practical Approach to Computer Algorithms
Essential Algorithms: A Practical Approach to Computer Algorithms

A friendly and accessible introduction to the most useful algorithms

Computer algorithms are the basic recipes for programming. Professional programmers need to know how to use algorithms to solve difficult programming problems. Written in simple, intuitive English, this book describes how and when to use the most practical...

Pro Java 8 Programming
Pro Java 8 Programming

Pro Java 8 Programming covers the core Java development kit. It takes advantage of the finer points of the core standard edition (SE) and development kit version 8. You'll discover the particulars of working with the Java language and APIs to develop applications in many different contexts. You will also delve into more advanced...

Data-Intensive Computing: Architectures, Algorithms, and Applications
Data-Intensive Computing: Architectures, Algorithms, and Applications

The world is awash with digital data from social networks, blogs, business, science, and engineering. Data-intensive computing facilitates understanding of complex problems that must process massive amounts of data. Through the development of new classes of software, algorithms, and hardware, data-intensive applications can provide timely and...

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