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

Buy

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

RHCE Red Hat Certified Engineer Linux: 100 Success Secrets on RHCE Linux Test Preparation, Study Guides, Practice Exams, Braindumps, Certification Exam
RHCE Red Hat Certified Engineer Linux: 100 Success Secrets on RHCE Linux Test Preparation, Study Guides, Practice Exams, Braindumps, Certification Exam
Red Hat Certified Engineer (RHCE) is a performance-based test that measures actual competency on live systems. Called the "crown jewel of Linux certifications," RHCE proves an individual's ability to configure networking services and security on servers running a Red Hat OS.

The rise of Red Hat has been marvelous to watch. Starting...

Fundamentals of the Fuzzy Logic-Based Generalized Theory of Decisions (Studies in Fuzziness and Soft Computing)
Fundamentals of the Fuzzy Logic-Based Generalized Theory of Decisions (Studies in Fuzziness and Soft Computing)

Every day decision making and decision making in complex human-centric systems are characterized by imperfect decision-relevant information. Main drawback of the existing decision theories is namely incapability to deal with imperfect information and modeling vague preferences. Actually, a paradigm of non-numerical probabilities in decision...

Red Hat Fedora Linux 2 All-in-One Desk Reference For Dummies
Red Hat Fedora Linux 2 All-in-One Desk Reference For Dummies
9 books in 1– one great price for nine handy, quick reference guides!

Your one-stop guide to the latest release of this popular Linux distribution

Get ready to tip your hat to the latest version of Fedora! From installing Fedora on your PC and using OpenOffice.org to securing your system and setting up servers, the nine...


Office and SharePoint 2010 User’s Guide: Integrating SharePoint with Excel, Outlook, Access and Word
Office and SharePoint 2010 User’s Guide: Integrating SharePoint with Excel, Outlook, Access and Word

Web sites, collaboration, document management, paperless offices—we want it all in business today, but how do we achieve all of these goals? More importantly, if you work for one of the millions of small-to-medium-sized businesses, how do you find the time to build the expertise necessary to reach these goals? Even the most powerful...

What is What in the Nanoworld: A Handbook on Nanoscience and Nanotechnology
What is What in the Nanoworld: A Handbook on Nanoscience and Nanotechnology

The third, partly revised and enlarged edition of this introductory reference summarizes the terms and definitions, most important phenomena, and regulations occurring in the physics, chemistry, technology, and application of nanostructures. A representative collection of fundamental terms and definitions from quantum physics and chemistry,...

The Elements of Statistical Learning: Data Mining, Inference, and Prediction, Second Edition (Springer Series in Statistics)
The Elements of Statistical Learning: Data Mining, Inference, and Prediction, Second Edition (Springer Series in Statistics)

This book describes the important ideas in a variety of fields such as medicine, biology, finance, and marketing in a common conceptual framework. While the approach is statistical, the emphasis is on concepts rather than mathematics. Many examples are given, with a liberal use of colour graphics. It is a valuable resource...

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