PostgreSQL 9.0 High Performance (Paperback)

Gregory Smith

  • 出版商: Packt Publishing
  • 出版日期: 2010-10-18
  • 定價: $1,750
  • 售價: 5.0$875
  • 語言: 英文
  • 頁數: 468
  • 裝訂: Paperback
  • ISBN: 184951030X
  • ISBN-13: 9781849510301
  • 相關分類: PostgreSQLSQL
  • 立即出貨(限量) (庫存=1)

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

商品描述

Accelerate your PostgreSQL system

 

  • Learn the right techniques to obtain optimal PostgreSQL database performance, from initial design to routine maintenance.
  • Discover the techniques used to scale successful database installations.
  • Avoid the common pitfalls that can slow your system down.
  • Filled with advice about what you should be doing; how to build experimental databases to explore performance topics, and then move what you've learned into a production database environment.
  • Covers versions 8.1 through 9.0.

In Detail
PostgreSQL database servers have a common set of problems they encounter as their usage gets heavier and requirements more demanding. You could spend years discovering solutions to them all, step by step as you encounter them. Or you can just look in here.

All successful database applications are destined to eventually run into issues scaling up their performance. Peek into the future of your PostgreSQL database's problems today. Know the warning signs to look for, and how to avoid the most common issues before they even happen.

Surprisingly, most PostgreSQL database applications evolve in the same way: Choose the right hardware. Tune the operating system and server memory use. Optimize queries against the database, with the right indexes. Monitor every layer, from hardware to queries, using some tools that are inside PostgreSQL and others that are external. Using monitoring insight, continuously rework the design and configuration. On reaching the limits of a single server, break things up; connection pooling, caching, partitioning, and replication can all help handle increasing database workloads.

The path to a high performance database system isn't always easy. But it doesn't have to be mysterious with the right guide.

Approach
A clear, step-by-step guide to optimizing and scaling up PostgreSQL database servers. Improving database performance requires an equal mix of understanding theoretical concepts and working through hands-on examples. You'll find both here. Many of the examples given will be immediately useful for monitoring and improving your PostgreSQL deployments, providing insight into hard-to-obtain information about your database.

 

商品描述(中文翻譯)

加速您的PostgreSQL系統

學習獲得最佳的PostgreSQL數據庫性能的正確技巧,從初始設計到日常維護。

發現成功擴展數據庫安裝所使用的技術。

避免可能減慢系統速度的常見問題。

充滿了關於您應該做什麼的建議;如何構建實驗數據庫以探索性能主題,然後將所學應用於生產數據庫環境。

涵蓋版本8.1到9.0。

詳細內容
PostgreSQL數據庫服務器在使用量增加和需求更高時都會遇到一組常見問題。您可以花費多年逐步發現解決方案。或者您可以在這裡找到答案。

所有成功的數據庫應用最終都會遇到性能擴展的問題。今天就預覽您的PostgreSQL數據庫問題的未來。了解要注意的警告信號,以及如何在問題發生之前避免最常見的問題。

令人驚訝的是,大多數PostgreSQL數據庫應用程序的演變方式都是相同的:選擇合適的硬件。調整操作系統和服務器內存使用。使用正確的索引對數據庫進行優化查詢。使用PostgreSQL內部和外部的一些工具,從硬件到查詢的每一層進行監控。使用監控洞察力,不斷重新設計和配置。在單個服務器達到極限時,進行分割;連接池、緩存、分區和複製都可以幫助處理不斷增加的數據庫工作量。

構建高性能數據庫系統的道路並不總是容易的。但是有了正確的指南,它不必成為神秘的。

方法
一個清晰的、逐步指南,用於優化和擴展PostgreSQL數據庫服務器。改善數據庫性能需要同樣理解理論概念和通過實際示例進行操作。這裡都有。其中許多示例對於監控和改善您的PostgreSQL部署將立即有用,提供有關數據庫的難以獲得的信息。