Mastering PostgreSQL 13 - Fourth Edition: Build, administer, and maintain database applications efficiently with PostgreSQL 13
暫譯: 精通 PostgreSQL 13 - 第四版：高效構建、管理和維護資料庫應用程式

Schönig, Hans-Jürgen

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

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

相關主題

商品描述

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 書籍結束時，您將能夠通過執行進階管理任務來充分利用您的資料庫。

#### 您將學到什麼

- 熟悉 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.

作者簡介(中文翻譯)

漢斯-尤根·肖尼格擁有18年的PostgreSQL經驗。他是名為Cybertec PostgreSQL International GmbH的PostgreSQL諮詢與支援公司的執行長，該公司成功地為全球無數客戶提供服務。在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

目錄大綱(中文翻譯)

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

類似商品