PostgreSQL High Performance Cookbook

Chitij Chauhan, Dinesh Kumar

  • 出版商: Packt Publishing
  • 出版日期: 2017-03-30
  • 定價: $1,780
  • 售價: 6.0$1,068
  • 語言: 英文
  • 頁數: 360
  • 裝訂: Paperback
  • ISBN: 1785284339
  • ISBN-13: 9781785284335
  • 相關分類: PostgreSQLSQL
  • 立即出貨 (庫存=1)

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

商品描述

Key Features

  • Perform essential database tasks such as benchmarking the database and optimizing the server's memory usage
  • Learn ways to improve query performance and optimize the PostgreSQL server
  • Explore a wide range of high availability and replication mechanisms to build robust, highly available, scalable, and fault-tolerant PostgreSQL databases

Book Description

PostgreSQL is one of the most powerful and easy to use database management systems. It has strong support from the community and is being actively developed with a new release every year. PostgreSQL supports the most advanced features included in SQL standards. It also provides NoSQL capabilities and very rich data types and extensions. All of this makes PostgreSQL a very attractive solution in software systems.

If you run a database, you want it to perform well and you want to be able to secure it. As the world's most advanced open source database, PostgreSQL has unique built-in ways to achieve these goals. This book will show you a multitude of ways to enhance your database's performance and give you insights into measuring and optimizing a PostgreSQL database to achieve better performance.

This book is your one-stop guide to elevate your PostgreSQL knowledge to the next level. First, you'll get familiarized with essential developer/administrator concepts such as load balancing, connection pooling, and distributing connections to multiple nodes. Next, you will explore memory optimization techniques before exploring the security controls offered by PostgreSQL. Then, you will move on to the essential database/server monitoring and replication strategies with PostgreSQL. Finally, you will learn about query processing algorithms.

What you will learn

  • Build replication strategies for homogeneous and heterogeneous databases
  • Test and build a secure PostgreSQL database with the Metasploit framework
  • Get to know a few SQL injection techniques
  • Find out how to monitor the database and operating system metrics
  • Benchmark the database server using multiple strategies
  • Work with the query processing algorithms and their internal behaviors
  • Build a proper plan to upgrade or migrate to PostgreSQL from other databases
  • See the essential database load balancing techniques and the various partitioning approaches PostgreSQL provides
  • Learn memory optimization techniques and database server configurations

商品描述(中文翻譯)

主要特點



  • 執行基本的資料庫任務,例如對資料庫進行基準測試和優化伺服器的記憶體使用

  • 學習改善查詢效能和優化PostgreSQL伺服器的方法

  • 探索各種高可用性和複寫機制,以建立堅固、高可用性、可擴展和容錯的PostgreSQL資料庫

書籍描述


PostgreSQL是最強大且易於使用的資料庫管理系統之一。它得到社群的大力支持,並且每年都有新版本的積極開發。PostgreSQL支援SQL標準中包含的最先進功能。它還提供NoSQL功能、非常豐富的資料類型和擴充功能。所有這些使得PostgreSQL在軟體系統中成為非常有吸引力的解決方案。


如果您運行一個資料庫,您希望它運行良好並且能夠保護它。作為世界上最先進的開源資料庫,PostgreSQL具有獨特的內建方法來實現這些目標。本書將向您展示多種提升資料庫效能的方法,並為您提供測量和優化PostgreSQL資料庫以實現更好效能的見解。


本書是您提升PostgreSQL知識的一站式指南。首先,您將熟悉開發人員/管理員的基本概念,例如負載平衡、連接池和將連接分配給多個節點。接下來,您將探索記憶體優化技術,然後探索PostgreSQL提供的安全控制。然後,您將轉向使用PostgreSQL進行必要的資料庫/伺服器監控和複寫策略。最後,您將學習查詢處理算法。

您將學到什麼



  • 建立同質和異質資料庫的複寫策略

  • 使用Metasploit框架測試和建立安全的PostgreSQL資料庫

  • 了解一些SQL注入技術

  • 了解如何監控資料庫和作業系統指標

  • 使用多種策略對資料庫伺服器進行基準測試

  • 使用查詢處理算法及其內部行為

  • 制定適當的升級或從其他資料庫遷移至PostgreSQL的計劃

  • 了解必要的資料庫負載平衡技術和PostgreSQL提供的各種分區方法

  • 學習記憶體優化技術和資料庫伺服器配置