PostgreSQL 10 High Performance

Ibrar Ahmed, Gregory Smith, Enrico Pirozzi

  • 出版商: Packt Publishing
  • 出版日期: 2018-04-30
  • 售價: $1,830
  • 貴賓價: 9.5$1,739
  • 語言: 英文
  • 頁數: 508
  • 裝訂: Paperback
  • ISBN: 1788474481
  • ISBN-13: 9781788474481
  • 相關分類: PostgreSQLSQL
  • 下單後立即進貨 (約3~4週)

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

商品描述

Leverage the power of PostgreSQL 10 to design, administer and maintain a high-performance database solution Key Features Obtain optimal PostgreSQL 10 database performance, ranging from initial design to routine maintenance Fine tune the performance of your queries and avoid the common pitfalls that can slow your system down Contains tips and tricks on scaling successful database installations, and ensuring a highly available PostgreSQL solution Book DescriptionPostgreSQL database servers have a common set of problems that they encounter as their usage gets heavier and requirements get more demanding. Peek into the future of your PostgreSQL 10 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 and CPUs with the right indexes, and monitor every layer, from hardware to queries, using tools from inside and outside PostgreSQL. Also, using monitoring insight, PostgreSQL database applications continuously rework the design and configuration. On reaching the limits of a single server, they break things up; connection pooling, caching, partitioning, replication, and parallel queries can all help handle increasing database workloads. By the end of this book, you will have all the knowledge you need to design, run, and manage your PostgreSQL solution while ensuring high performance and high availability What you will learn Learn best practices for scaling PostgreSQL 10 installations Discover the best hardware for developing high-performance PostgreSQL applications Benchmark your whole system - from hardware to application Learn by real examples how server parameters impact performance Discover PostgreSQL 10 features for partitioning and parallel query Monitor your server, both inside and outside the database Design and implement a good replication system on PostgreSQL 10 Who this book is forThis book is designed for database administrators and PostgreSQL architects who already use or plan to exploit the features of PostgreSQL 10 to design and maintain a high-performance PostgreSQL database. A working knowledge of SQL, and some experience with PostgreSQL will be helpful in getting the most out of this book.

商品描述(中文翻譯)

發揮 PostgreSQL 10 的威力,設計、管理和維護高效能的資料庫解決方案 主要特點 從初始設計到日常維護,獲得最佳的 PostgreSQL 10 資料庫效能 微調查詢效能,避免常見的可能降低系統效能的問題 提供成功資料庫安裝的擴展和高可用性 PostgreSQL 解決方案的技巧和訣竅 書籍描述 PostgreSQL 資料庫伺服器在使用量增加和需求變得更加苛刻時,都會遇到一組共同的問題。今天就預測您的 PostgreSQL 10 資料庫可能遇到的問題。了解要注意的警示標誌,以及如何在問題發生之前避免最常見的問題。令人驚訝的是,大多數 PostgreSQL 資料庫應用程式都會以相同的方式演進-選擇合適的硬體,調整作業系統和伺服器記憶體使用,使用正確的索引對資料庫和 CPU 進行查詢優化,並使用 PostgreSQL 內部和外部的工具監控從硬體到查詢的每一層。此外,使用監控洞察力,PostgreSQL 資料庫應用程式會持續重新設計和配置。當單一伺服器達到極限時,它們會將事物分割;連線池、快取、分區、複寫和平行查詢都可以幫助處理不斷增加的資料庫工作量。通過閱讀本書,您將獲得設計、運行和管理 PostgreSQL 解決方案所需的所有知識,同時確保高效能和高可用性。 您將學到什麼 學習 PostgreSQL 10 安裝的最佳實踐 發現開發高效能 PostgreSQL 應用程式的最佳硬體 從硬體到應用程式,對整個系統進行基準測試 通過實際範例了解伺服器參數如何影響效能 發現 PostgreSQL 10 的分區和平行查詢功能 監控伺服器,包括資料庫內部和外部 設計並實施一個良好的 PostgreSQL 10 複寫系統 本書適合對象 本書適用於資料庫管理員和 PostgreSQL 架構師,他們已經使用或計劃利用 PostgreSQL 10 的功能來設計和維護高效能的 PostgreSQL 資料庫。具備 SQL 的工作知識,以及一些 PostgreSQL 的經驗將有助於更好地理解本書的內容。