Mastering PostgreSQL 12: Advanced techniques to build and administer scalable and reliable PostgreSQL database applications, 3/e (Paperback)

Schonig, Hans-Jurgen

商品描述

 
Learn
  • Understand the advanced SQL functions in PostgreSQL 12
  • Use indexing features in PostgreSQL to fine-tune the performance of queries
  • Work with stored procedures and manage backup and recovery
  • Master replication and failover techniques to reduce data loss
  • Replicate PostgreSQL database systems to create backups and to scale your database
  • Manage and improve the security of your server to protect your data
  • Troubleshoot your PostgreSQL instance for solutions to common and not-so-common problems
About

Thanks to its reliability, robustness, and high performance, PostgreSQL has become the most advanced open source database on the market. This third edition of Mastering PostgreSQL helps you build dynamic database solutions for enterprise applications using the latest release of PostgreSQL, which enables database analysts to design both physical and technical aspects of system architecture with ease.

Starting with an introduction to the newly released features in PostgreSQL 12, this book will help you build efficient and fault-tolerant PostgreSQL applications. You’ll thoroughly examine the advanced features of PostgreSQL, including logical replication, database clusters, performance tuning, monitoring, and user management. You’ll also work with the PostgreSQL optimizer, configure PostgreSQL for high speed, and understand how to move from Oracle to PostgreSQL. As you progress through the chapters, you’ll cover transactions, locking, indexes, and how to optimize queries for improved performance. Additionally, you’ll learn how to manage network security and explore backups and replications while understanding useful PostgreSQL extensions to help you in optimizing the performance of large databases.

By the end of this PostgreSQL book, you’ll be able to get the most out of your database by implementing advanced administrative tasks effortlessly.

Features
  • Grasp advanced PostgreSQL 12 concepts with real-world examples and sample datasets
  • Explore query parallelism, data replication, database administration, and more
  • Extend PostgreSQL functionalities to suit your organization’s needs with minimal effort

商品描述(中文翻譯)

 


學習


  • 了解 PostgreSQL 12 中的高級 SQL 函數

  • 使用 PostgreSQL 的索引功能來調整查詢的效能

  • 使用儲存過程並管理備份和恢復

  • 掌握複寫和故障轉移技術以減少數據損失

  • 複製 PostgreSQL 數據庫系統以創建備份並擴展您的數據庫

  • 管理和提升伺服器的安全性以保護您的數據

  • 為常見和不太常見的問題解決您的 PostgreSQL 實例





關於

由於其可靠性、強大性和高性能,PostgreSQL 已成為市場上最先進的開源數據庫。《Mastering PostgreSQL》第三版將幫助您使用最新版本的 PostgreSQL 為企業應用程序構建動態數據庫解決方案,使數據庫分析師能夠輕鬆設計系統架構的物理和技術方面。

從介紹 PostgreSQL 12 的新功能開始,本書將幫助您構建高效且容錯的 PostgreSQL 應用程序。您將深入研究 PostgreSQL 的高級功能,包括邏輯複寫、數據庫集群、性能調整、監控和用戶管理。您還將使用 PostgreSQL 優化器,配置高速 PostgreSQL,並了解如何從 Oracle 遷移到 PostgreSQL。隨著章節的進展,您將涵蓋事務、鎖定、索引以及如何優化查詢以提高性能。此外,您還將學習如何管理網絡安全性,探索備份和複寫,同時了解有用的 PostgreSQL 擴展,以幫助您優化大型數據庫的性能。

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





特點


  • 通過實例和樣本數據集掌握 PostgreSQL 12 的高級概念

  • 探索查詢並行處理、數據複寫、數據庫管理等功能

  • 以最小的努力擴展 PostgreSQL 功能以滿足組織的需求