Mastering PostgreSQL 17 - Sixth Edition: Elevate your database skills with advanced deployment, optimization, and security strategies
暫譯: 精通 PostgreSQL 17 - 第六版:提升您的資料庫技能,掌握進階部署、優化與安全策略

Schönig, Hans-Jürgen

  • 出版商: Packt Publishing
  • 出版日期: 2024-12-27
  • 售價: $2,100
  • 貴賓價: 9.5$1,995
  • 語言: 英文
  • 頁數: 474
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 183620597X
  • ISBN-13: 9781836205975
  • 相關分類: PostgreSQLSQL資料庫資訊安全
  • 海外代購書籍(需單獨結帳)

商品描述

Learn advanced PostgreSQL techniques vital for everyday operation and security with a focus on PostgreSQL 17, its new features, and evolving real-world applications

Key Features:

- Optimize queries and performance for PostgreSQL installations

- Secure databases with advanced access controls and encryption

- Master replication, backups, and disaster recovery strategies

- Purchase of the print or Kindle book includes a free PDF eBook

Book Description:

Starting with new features introduced in PostgreSQL 17, the sixth edition of this book provides comprehensive insights into advanced database management, helping you elevate your PostgreSQL skills to an expert level. Written by Hans-Jürgen Schönig, a PostgreSQL expert with over 25 years of experience and the CEO of CYBERTEC PostgreSQL International GmbH, this guide distills real-world expertise from supporting countless global customers. It guides you through crucial aspects of professional database management, including performance tuning, replication, indexing, and security strategies.

You'll learn how to handle complex queries, optimize execution plans, and enhance user interactions with advanced SQL features such as window functions and JSON support. Hans equips you with practical approaches for managing database locks, transactions, and stored procedures to ensure peak performance. With real-world examples and expert solutions, you'll also explore replication techniques for high availability, along with troubleshooting methods to detect and resolve bottlenecks, preparing you to tackle everyday challenges in database administration.

By the end of the book, you'll be ready to deploy, secure, and maintain PostgreSQL databases efficiently in production environments.

What You Will Learn:

- Deploy and manage PostgreSQL in production environments

- Improve database throughput and ensure speedy responses from PostgreSQL

- Utilize indexes, partitions, and full-text search

- Handle transactions, locking, and concurrency issues

- Secure PostgreSQL with encryption and access controls

- Implement replication for high availability

- Get to grips with handling redundancy and data safety

- Fix the most common issues and real-world problems faced by PostgreSQL users

Who this book is for:

This book is for database administrators, PostgreSQL developers, and IT professionals who want to implement advanced functionalities and tackle complex administrative tasks using PostgreSQL 17. A foundational understanding of PostgreSQL and core database concepts is essential, along with familiarity with SQL. Prior experience in database administration will enhance your ability to leverage the advanced techniques presented in this book.

Table of Contents

- What is New in PostgreSQL 17

- Understanding Transactions and Locking

- Making Use of Indexes

- Handling Advanced SQL

- Log Files and System Statistics

- Optimizing Queries for Good Performance

- Writing Stored Procedures

- Managing PostgreSQL Security

- Handling Backup and Recovery

- Making Sense of Backups and Replication

- Deciding on Useful Extensions

- Troubleshooting PostgreSQL

- Migrating to PostgreSQL

商品描述(中文翻譯)

學習對日常操作和安全至關重要的進階 PostgreSQL 技術,重點關注 PostgreSQL 17 的新功能及其不斷演變的實際應用

主要特點:
- 優化 PostgreSQL 安裝的查詢和性能
- 使用進階訪問控制和加密來保護資料庫
- 精通複製、備份和災難恢復策略
- 購買印刷版或 Kindle 書籍可獲得免費 PDF 電子書

書籍描述:
本書第六版從 PostgreSQL 17 中引入的新功能開始,提供了對進階資料庫管理的全面見解,幫助您將 PostgreSQL 技能提升至專家級別。這本指南由擁有超過 25 年經驗的 PostgreSQL 專家 Hans-Jürgen Schönig 撰寫,他是 CYBERTEC PostgreSQL International GmbH 的首席執行官,該指南提煉了支持無數全球客戶的實際專業知識。它引導您了解專業資料庫管理的關鍵方面,包括性能調優、複製、索引和安全策略。

您將學會如何處理複雜查詢、優化執行計劃,並利用進階 SQL 功能(如窗口函數和 JSON 支持)增強用戶互動。Hans 為您提供管理資料庫鎖、事務和存儲過程的實用方法,以確保最佳性能。通過實際案例和專家解決方案,您還將探索高可用性的複製技術,以及檢測和解決瓶頸的故障排除方法,幫助您應對資料庫管理中的日常挑戰。

在書籍結束時,您將能夠有效地在生產環境中部署、保護和維護 PostgreSQL 資料庫。

您將學到的內容:
- 在生產環境中部署和管理 PostgreSQL
- 提高資料庫吞吐量,確保 PostgreSQL 的快速響應
- 利用索引、分區和全文搜索
- 處理事務、鎖定和併發問題
- 使用加密和訪問控制來保護 PostgreSQL
- 實施高可用性的複製
- 理解冗餘和數據安全的處理
- 解決 PostgreSQL 使用者面臨的最常見問題和實際問題

本書適合誰:
本書適合資料庫管理員、PostgreSQL 開發人員和希望使用 PostgreSQL 17 實施進階功能並處理複雜管理任務的 IT 專業人員。對 PostgreSQL 和核心資料庫概念的基礎理解是必需的,並且需要熟悉 SQL。先前的資料庫管理經驗將增強您利用本書中介紹的進階技術的能力。

目錄
- PostgreSQL 17 的新功能
- 理解事務和鎖定
- 利用索引
- 處理進階 SQL
- 日誌文件和系統統計
- 優化查詢以獲得良好性能
- 編寫存儲過程
- 管理 PostgreSQL 安全性
- 處理備份和恢復
- 理解備份和複製
- 決定有用的擴展
- 故障排除 PostgreSQL
- 遷移到 PostgreSQL