Mastering PostgreSQL 11: Expert techniques to build scalable, reliable, and fault-tolerant database applications, 2/e (Paperback)

Hans-Jurgen Schonig

買這商品的人也買了...

商品描述

Master the capabilities of PostgreSQL 11 to efficiently manage and maintain your database

Key Features

  • Master advanced concepts of PostgreSQL 11 with real-world datasets and examples
  • Explore query parallelism, data replication, and database performance while working with larger datasets
  • Extend the functionalities of your PostgreSQL instance to suit your organization's needs with minimal effort

Book Description

This second edition of Mastering PostgreSQL 11 helps you build dynamic database solutions for enterprise applications using the latest release of PostgreSQL, which enables database analysts to design both the physical and technical aspects of the system architecture with ease.

This book begins with an introduction to the newly released features in PostgreSQL 11 to help you build efficient and fault-tolerant PostgreSQL applications. You'll examine all of the advanced aspects of PostgreSQL in detail, including logical replication, database clusters, performance tuning, monitoring, and user management. You will also work with the PostgreSQL optimizer, configuring PostgreSQL for high speed, and see how to move from Oracle to PostgreSQL. As you progress through the chapters, you will cover transactions, locking, indexes, and optimizing queries to improve performance. Additionally, you'll learn to manage network security and explore backups and replications, while understanding the useful extensions of PostgreSQL so that you can optimize the speed and performance of large databases.

By the end of this book, you will be able to use your database to its utmost capacity by implementing advanced administrative tasks with ease.

What you will learn

  • Get to grips with advanced PostgreSQL 11 features and SQL functions
  • Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries
  • Work with stored procedures and manage backup and recovery
  • Master replication and failover techniques
  • Troubleshoot your PostgreSQL instance for solutions to common and not-so-common problems
  • Perform database migration from MySQL and Oracle to PostgreSQL with ease

Who this book is for

This book is for data and database professionals wanting to implement advanced functionalities and master complex administrative tasks with PostgreSQL 11. Prior experience of database administration with PostgreSQL database will aid in understanding the concepts covered in this book.

Table of Contents

  1. PostgreSQL Overview
  2. Understanding Transactions and Locking
  3. Making Use of Indexes
  4. Handling Advanced SQL
  5. Log Files and System Statistics
  6. Optimizing Queries for Good Performance
  7. Writing Stored Procedures
  8. Managing PostgreSQL Security
  9. Handling Backup and Recovery
  10. Making Sense of Backups and Replication
  11. Deciding on Useful Extensions
  12. Troubleshooting PostgreSQL
  13. Migrating to PostgreSQL

商品描述(中文翻譯)

掌握 PostgreSQL 11 的能力,有效地管理和維護您的資料庫

主要特點

- 通過真實世界的數據集和示例,掌握 PostgreSQL 11 的高級概念
- 在處理更大的數據集時,探索查詢並行處理、數據複製和資料庫性能
- 以最小的努力擴展您的 PostgreSQL 實例的功能,以滿足組織的需求

書籍描述

《精通 PostgreSQL 11》第二版幫助您使用最新版本的 PostgreSQL 為企業應用程序構建動態的資料庫解決方案,使資料庫分析師能夠輕鬆設計系統架構的物理和技術方面。

本書首先介紹 PostgreSQL 11 的新功能,幫助您建立高效且容錯的 PostgreSQL 應用程序。您將詳細研究 PostgreSQL 的所有高級方面,包括邏輯複製、資料庫集群、性能調整、監控和用戶管理。您還將使用 PostgreSQL 優化器,配置 PostgreSQL 實現高速度,並了解從 Oracle 遷移到 PostgreSQL 的方法。隨著章節的進展,您將涵蓋事務、鎖定、索引和優化查詢以提高性能。此外,您還將學習管理網絡安全性,探索備份和複製,並了解 PostgreSQL 的有用擴展,以便優化大型資料庫的速度和性能。

通過閱讀本書,您將能夠輕鬆實施高級管理任務,充分發揮您的資料庫的能力。

您將學到什麼

- 瞭解 PostgreSQL 11 的高級功能和 SQL 函數
- 利用 PostgreSQL 的索引功能,調整查詢的性能
- 使用存儲過程並管理備份和恢復
- 掌握複製和故障轉移技術
- 解決常見和不常見問題的 PostgreSQL 實例故障排除
- 輕鬆將資料庫從 MySQL 和 Oracle 遷移到 PostgreSQL

本書適合對 PostgreSQL 11 實施高級功能和掌握複雜管理任務的數據和資料庫專業人士。具有 PostgreSQL 資料庫管理經驗將有助於理解本書涵蓋的概念。

目錄

1. PostgreSQL 概述
2. 瞭解事務和鎖定
3. 利用索引
4. 處理高級 SQL
5. 日誌文件和系統統計
6. 優化查詢以獲得良好性能
7. 編寫存儲過程
8. 管理 PostgreSQL 安全性
9. 處理備份和恢復
10. 理解備份和複製
11. 選擇有用的擴展
12. 故障排除 PostgreSQL
13. 遷移到 PostgreSQL