Mastering PostgreSQL 9.6 (Paperback)

Hans-Jurgen Schonig

相關主題

商品描述

Key Features

  • Your one-stop guide to mastering the advanced concepts in PostgreSQL with ease
  • Master query optimization, replication, and high availability with PostgreSQL
  • Extend the functionalities of PostgreSQL to suit your organizational needs with minimum effort

Book Description

PostgreSQL is an open source database management tool used for handling large datasets (big data) and as a JSON document database. It also has applications in the software and web domains. This book will enable you to build better PostgreSQL applications and administer databases more efficiently.

We begin by explaining the advanced database design concepts in PostgreSQL 9.6, along with indexing and query optimization. You will also see how to work with event triggers and perform concurrent transactions and table partitioning, along with exploring SQL and server tuning. We will walk you through implementing advanced administrative tasks such as server maintenance and monitoring, replication, recovery and high availability, and much more. You will understand the common and not-so-common troubleshooting problems and how you can overcome them.

By the end of this book, you will have an expert-level command of the advanced database functionalities and will be able to implement advanced administrative tasks with PostgreSQL.

What you will learn

  • Explore the new features of PostgreSQL 9.6 and PostgreSQL 10.0
  • See how to administer PostgreSQL effectively using a variety of methods
  • Understand a variety of techniques to optimize your database to get a better performance
  • Find out how to create a professional database cluster
  • Get to know how to monitor PostgreSQL step by step
  • Dive into advanced SQL and its features

商品描述(中文翻譯)

《PostgreSQL高級概念與管理》

主要特點


  • 一站式指南,輕鬆掌握PostgreSQL的高級概念

  • 掌握PostgreSQL的查詢優化、複寫和高可用性

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

書籍描述

PostgreSQL是一個用於處理大型數據集(大數據)和作為JSON文檔數據庫的開源數據庫管理工具。它在軟件和網絡領域也有應用。本書將幫助您構建更好的PostgreSQL應用程序並更有效地管理數據庫。

我們首先解釋了PostgreSQL 9.6的高級數據庫設計概念,包括索引和查詢優化。您還將了解如何使用事件觸發器進行工作,執行並發事務和表分區,以及探索SQL和服務器調優。我們將引導您實施高級管理任務,如服務器維護和監控、複寫、恢復和高可用性等。您將了解常見和不太常見的故障排除問題以及如何克服它們。

通過閱讀本書,您將具備高級數據庫功能的專家級掌握能力,並能夠使用PostgreSQL實施高級管理任務。

您將學到什麼


  • 探索PostgreSQL 9.6和PostgreSQL 10.0的新功能

  • 了解使用各種方法有效管理PostgreSQL的技巧

  • 瞭解各種優化技術,以獲得更好的數據庫性能

  • 了解如何創建專業的數據庫集群

  • 瞭解如何逐步監控PostgreSQL

  • 深入研究高級SQL及其功能