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

BPEL and Java Cookbook
BPEL and Java Cookbook

Written by an SOA guru to help you orchestrate web services, the 100 recipes in this book will make integrating Java and BPEL a smooth process. Using the examples you'll avoid common problems and learn sophisticated techniques.


  • Easy-to-understand recipes for integrating Java and BPEL
  • ...
Metaprogramming Ruby
Metaprogramming Ruby

Ruby inherits characteristics from various languages—Lisp, Smalltalk, C, and Perl, to name a few. Metaprogramming comes from Lisp (and Smalltalk). It’s a bit like magic, which makes something astonishing possible. There are two kinds of magic: white magic, which does good things, and black magic, which can do nasty things. Likewise,...

VMware vSphere 5.5 Cookbook
VMware vSphere 5.5 Cookbook

A task-oriented guide with over 150 practical recipes to install, configure, and manage VMware vSphere components

About This Book

  • Explore the use of command line interface (CLI) to consistently configure the environment and automate it reasonably
  • Discover the best practices to deploy...

ABAP Cookbook: Programming Recipes for Everyday Solutions, SAP ABAP
ABAP Cookbook: Programming Recipes for Everyday Solutions, SAP ABAP

With this book, get answers to typical ABAP development problems or tasks: persistence programming, interface programming, security and tracing techniques, etc. The complexity of the recipes ranges from the simple starter plates to the complex main courses and some sweet deserts, of course! Each chapter is a short tutorial in itself, all...

Financial Accounting: An Introduction (5th Edition)
Financial Accounting: An Introduction (5th Edition)

Financial Accounting: an Introduction is aimed at first-level undergraduates on business studies degrees taking introductory financial accounting classes; first-level specialist accounting undergraduate students; introductory core accounting for MBA and postgraduate specialist Masters students (e.g. finance, actuarial studies),...

Developing Applications with Salesforce Chatter
Developing Applications with Salesforce Chatter

Make your business more social with Salesforce Chatter. This book walks you through configuring and customizing Chatter to boost collaboration in your organization. Can be used as a reference book or complete guide.


  • Understand Salesforce Chatter and its architecture.
  • Configure and...
©2017 LearnIT (support@pdfchm.net) - Privacy Policy