PostgreSQL for Data Architects

Jayadevan Maymala

PostgreSQL for Data Architects
  • 出版商: Packt Publishing
  • 出版日期: 2015-03-31
  • 售價: $2,050
  • 貴賓價: 9.5 折 $1,948
  • 語言: 英文
  • 頁數: 290
  • 裝訂: Paperback
  • ISBN: 1783288604
  • ISBN-13: 9781783288601
  • 相關分類: PostgreSQL、SQL

    • 下單後立即進貨 (約3~4週)

商品描述

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.

商品描述(中文翻譯)

發現如何有效地設計、開發和維護您的 PostgreSQL 資料庫應用程式

關於本書



  • 了解如何使用最常用的 PostgreSQL 生態系相關工具和技術

  • 一本實用指南，主要提供資料庫架構師學習架構和設計考量的實際方法

  • 本書從資料架構師的角度介紹 PostgreSQL，包括從源碼安裝到使用 SQL Power Architect 設計表格，以及決定複寫和故障轉移策略等主題。

本書適合對象


本書適合開發人員和資料架構師，他們對資料庫有一些了解。假設您了解表格和常見資料庫物件的基本概念，包括權限和安全性。

您將學到什麼



  • 從源碼編譯 PostgreSQL，了解 PostgreSQL 架構

  • 配置參數並更改 PostgreSQL 伺服器的預設設定

  • 利用日誌機制識別錯誤和次佳查詢

  • 使用複寫進行水平擴展

  • 建立備份和恢復流程

  • 微調參數以優化查詢和處理程序

  • 排除連線錯誤

  • 使用索引和重寫查詢以提高效能

  • 安裝和使用 PostgreSQL 擴充功能

  • 學習如何利用命令行客戶端 (psql)

詳細內容


PostgreSQL 是一個非常靈活和可靠的開源關聯式資料庫。利用它的功能，您的應用程式將更可靠、可擴展，而不會增加成本。一旦您發現如何設定它，使用 PostgreSQL 的高級功能將為您節省工作並提高效能。


《PostgreSQL for Data Architects》將教您一切必要的知識，以便建立一個可擴展和優化的 PostgreSQL 伺服器。


本書從基本概念開始，例如從源碼安裝 PostgreSQL，並涵蓋理論方面，如並發性和交易管理。之後，您將學習如何設定複寫、使用負載平衡進行水平擴展並排除錯誤。


最後，您將熟悉 PostgreSQL 生態系統中可用於分析 PostgreSQL 日誌、設定負載平衡和恢復的有用工具。

類似商品