Mastering PostgreSQL 15 : Advanced techniques to build and manage scalable, reliable, and fault-tolerant database applications, 5/e (Paperback)

Master the capabilities of PostgreSQL 15 to efficiently administer and maintain your database.

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

Key Features

• Using real world examples, get to grips with expert PostgreSQL 15 concepts
• Explore performance improvement, database replication, data replication, database administration, and more
• Extend PostgreSQL's functionalities to suit your organization's needs with minimal effort

Book Description

Starting with an introduction to the newly released features of PostgreSQL 15, this updated fifth edition will help you get to grips with PostgreSQL administration and how to build dynamic database solutions for enterprise apps, including designing both physical and technical aspects of the system.

You'll explore advanced PostgreSQL features, such as logical replication, database clusters, advanced indexing, and user management to manage and maintain your database. You'll then work with the PostgreSQL optimizer, configure PostgreSQL for high speed, and move from Oracle to PostgreSQL. Among the other skills that the book will help you build, you'll cover transactions, handling recursions, working with JSON and JSONB data, and setting up a Patroni cluster. It will show you how to improve performance with query optimization. You'll also focus on managing network security and work with backups and replication while exploring useful PostgreSQL extensions that optimize the performance of large databases.

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

What you will learn

• 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
• Get the hang of replication and failover techniques
• Improve the security of your database server and handle encryption effectively
• Troubleshoot your PostgreSQL instance for solutions to common and not-so-common problems
• Perform database migration from Oracle to PostgreSQL with ease

Who this book is for

This database administration book is for PostgreSQL developers, database administrators, and professionals who want to implement advanced functionalities and master complex administrative tasks with PostgreSQL 15. Prior experience in PostgreSQL and familiarity with the basics of database administration will assist with understanding key concepts covered in the book.

掌握 PostgreSQL 15 的功能，有效地管理和維護您的資料庫。

購買印刷版或 Kindle 版本的書籍，即可免費獲得 PDF 電子書。

主要特點：

- 通過實際案例，深入了解專業的 PostgreSQL 15 概念
- 探索性能改進、資料庫複製、數據複製、資料庫管理等方面
- 以最小的努力擴展 PostgreSQL 的功能，以滿足組織的需求

書籍描述：

從介紹 PostgreSQL 15 的新功能開始，這本更新的第五版將幫助您瞭解 PostgreSQL 管理和構建企業應用的動態資料庫解決方案，包括設計系統的物理和技術方面。

您將探索高級的 PostgreSQL 功能，如邏輯複製、資料庫集群、高級索引和用戶管理，以管理和維護您的資料庫。然後，您將使用 PostgreSQL 優化器，配置高速 PostgreSQL，並從 Oracle 遷移到 PostgreSQL。除了幫助您建立的其他技能外，您還將涵蓋事務、處理遞迴、使用 JSON 和 JSONB 數據以及設置 Patroni 集群。它將向您展示如何通過查詢優化來提高性能。您還將重點關注管理網絡安全，並在探索有用的 PostgreSQL 擴展時進行備份和複製，以優化大型資料庫的性能。

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

您將學到什麼：

- 利用 PostgreSQL 的索引功能，調整查詢性能
- 使用存儲過程，管理備份和恢復
- 掌握複製和故障轉移技術
- 提高資料庫伺服器的安全性，有效處理加密
- 解決常見和不常見問題的 PostgreSQL 實例故障排除
- 輕鬆從 Oracle 遷移到 PostgreSQL 進行資料庫遷移

本書適合對象：

本書適用於 PostgreSQL 開發人員、資料庫管理員和專業人士，他們希望實施高級功能並掌握 PostgreSQL 15 的複雜管理任務。具有 PostgreSQL 的先前經驗和對資料庫管理基礎知識的熟悉將有助於理解本書中涵蓋的關鍵概念。

1. PostgreSQL 15 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

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