Mastering PostgreSQL 13 - Fourth Edition: Build, administer, and maintain database applications efficiently with PostgreSQL 13

Schönig, Hans-Jürgen

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

商品描述

Explore expert techniques such as advanced indexing and high availability to build scalable, reliable, and fault-tolerant database applications using PostgreSQL 13

Key Features

  • Master advanced PostgreSQL 13 concepts with the help of real-world datasets and examples
  • Leverage PostgreSQL's indexing features to fine-tune the performance of your queries
  • Extend PostgreSQL's functionalities to suit your organization's needs with minimal effort

Book Description

Thanks to its reliability, robustness, and high performance, PostgreSQL has become one of the most advanced open source databases on the market. This updated fourth edition will help you understand PostgreSQL administration and how to build dynamic database solutions for enterprise apps with the latest release of PostgreSQL, including designing both physical and technical aspects of the system architecture with ease.

Starting with an introduction to the new features in PostgreSQL 13, this book will guide you in building efficient and fault-tolerant PostgreSQL apps. You'll explore advanced PostgreSQL features, such as logical replication, database clusters, performance tuning, advanced indexing, monitoring, 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. The book also covers transactions, locking, and indexes, and shows you how to improve performance with query optimization. You'll also focus on how to manage 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 get the most out of your database by executing advanced administrative tasks.

What you will learn

  • Get well versed with advanced SQL functions in PostgreSQL 13
  • Get to grips with administrative tasks such as log file management and monitoring
  • Work with stored procedures and manage backup and recovery
  • Employ replication and failover techniques to reduce data loss
  • Perform database migration from Oracle to PostgreSQL with ease
  • Replicate PostgreSQL database systems to create backups and scale your database
  • Manage and improve server security to protect your data
  • Troubleshoot your PostgreSQL instance to find solutions to common and not-so-common problems

Who this book is for

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

商品描述(中文翻譯)

探索專家技巧,如高級索引和高可用性,使用PostgreSQL 13構建可擴展、可靠和容錯的數據庫應用程序

主要特點


  • 通過真實世界的數據集和示例,掌握PostgreSQL 13的高級概念

  • 利用PostgreSQL的索引功能來調整查詢性能

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

書籍描述

由於其可靠性、強大性和高性能,PostgreSQL已成為市場上最先進的開源數據庫之一。這本更新的第四版將幫助您了解PostgreSQL管理和如何使用最新版本的PostgreSQL為企業應用程序構建動態數據庫解決方案,包括輕鬆設計系統架構的物理和技術方面。

從介紹PostgreSQL 13的新功能開始,本書將指導您構建高效且容錯的PostgreSQL應用程序。您將探索高級的PostgreSQL功能,如邏輯複製、數據庫集群、性能調優、高級索引、監控和用戶管理,以管理和維護您的數據庫。然後,您將使用PostgreSQL優化器,配置高速的PostgreSQL,並從Oracle遷移到PostgreSQL。本書還涵蓋了事務、鎖定和索引,並向您展示如何通過查詢優化來提高性能。您還將重點關注如何管理網絡安全性,以及如何使用備份和複製,同時探索有用的PostgreSQL擴展,以優化大型數據庫的性能。

通過閱讀本書,您將能夠通過執行高級管理任務充分利用您的數據庫。

您將學到什麼


  • 熟悉PostgreSQL 13中的高級SQL函數

  • 掌握管理任務,如日誌文件管理和監控

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

  • 使用複製和故障轉移技術減少數據損失

  • 輕鬆從Oracle遷移到PostgreSQL進行數據庫遷移

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

  • 管理和改善服務器安全性以保護您的數據

  • 排除PostgreSQL實例中的問題,找到解決常見和不太常見問題的解決方案

本書適合對象

這本數據庫管理書適用於PostgreSQL開發人員、數據庫管理員和專業人士,他們希望實施高級功能並掌握PostgreSQL 13的複雜管理任務。在閱讀本書之前,需要具備PostgreSQL的經驗和對數據庫管理基礎知識的熟悉,以便理解本書涵蓋的關鍵概念。

作者簡介

Hans-Jürgen Schönig has 18 years' experience with PostgreSQL. He is the CEO of a PostgreSQL consulting and support company called Cybertec PostgreSQL International GmbH. It has successfully served countless customers around the globe. Before founding Cybertec PostgreSQL International GmbH in 2000, he worked as a database developer at a private research company that focused on the Austrian labor market, where he primarily worked on data mining and forecast models. He has also written several books about PostgreSQL.

作者簡介(中文翻譯)

Hans-Jürgen Schönig 在 PostgreSQL 領域擁有 18 年的經驗。他是一家名為 Cybertec PostgreSQL International GmbH 的 PostgreSQL 諮詢和支援公司的 CEO。該公司成功地為全球眾多客戶提供服務。在 2000 年創辦 Cybertec PostgreSQL International GmbH 之前,他曾在一家專注於奧地利勞動市場的私人研究公司擔任數據庫開發人員,主要從事數據挖掘和預測模型的工作。他還撰寫了幾本關於 PostgreSQL 的書籍。

目錄大綱

Table of Contents

  1. PostgreSQL 13 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 13 概述

  2. 理解事務和鎖定

  3. 利用索引

  4. 處理進階 SQL

  5. 日誌文件和系統統計

  6. 優化查詢以獲得良好性能

  7. 撰寫儲存過程

  8. 管理 PostgreSQL 安全性

  9. 處理備份和恢復

  10. 理解備份和複寫

  11. 選擇有用的擴展

  12. 解決 PostgreSQL 問題

  13. 遷移到 PostgreSQL