【独家发布】PostgreSQL 9.6 High Performance

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

PostgreSQL 9.6 High Performance2017年7月25日G117 views发表评论阅读评论

1. PostgreSQL 9.6 High Performance
   
2. Authors: Ibrar Ahmed – Gregory Smith
   
3. ISBN-10 书号: 1784392979
   
4. ISBN-13 书号: 9781784392970
   
5. Edition: 2nd Revised edition
   
6. Release 出版日期: 2017-05-31
   
7. pages 页数: (508)
   
8. 49.99
   
9. 
   
10. Book Description
    
11. Enhance the performance of your PostgreSQL system with this handy guide while avoiding common pitfalls that can slow it down.
    
12. 
    
13. About This Book
    
14. Learn the right techniques to obtain optimal PostgreSQL database performance, ranging from initial design to routine maintenance
    
15. Fine tune the performance of your queries and avoid the common pitfalls that can slow your system down
    
16. Contains tips and tricks on scaling successful database installations, and ensuring a highly available PostgreSQL solution
    
17. Who This Book Is For
    
18. This book is for intermediate to advanced database administrators and developers who use or plan to exploit the features of PostgreSQL in the best possible manner. While administrators can benefit from the topics related to the installation, configuration, and optimization of the server, developers will learn how to write optimal queries and address performance issues in their database design. This book will also benefit the PostgreSQL internal architects in being able to monitor the performance using benchmarking tools.
    
19. 
    
20. What You Will Learn
    
21. Learn the best practices to configure your PostgreSQL 9.6 database for optimal performance
    
22. Write optimal queries and techniques to detect performance issue in queries
    
23. Fine tune the performance of your queries using benchmarking and indexing techniques
    
24. Ensure high performance and a highly available database using the scaling and replication techniques
    
25. Discover how to make informed speed and reliability trade-offs
    
26. Handle increasing database workloads without any hassle
    
27. Use monitoring insights to continuously rework the design and configuration for best performance
    
28. In Detail
    
29. Database administrators and developers spend years learning techniques to configure their PostgreSQL database servers for optimal performance, mostly when they encounter performance issues. Scalability and high availability of the database solution is equally important these days. This book will show you how to configure new database installations and optimize existing database server installations using PostgreSQL 9.6.
    
30. 
    
31. You will start with the basic concepts of database performance, because all successful database applications are destined to eventually run into issues when scaling up their performance. You will not only learn to optimize your database and queries for optimal performance, but also detect the real performance bottlenecks using PostgreSQL tools and some external tools. Next, you will learn how to benchmark your hardware and tune your operating system. Optimize your queries against the database with the help of right indexes, and monitor every layer, ranging from hardware to queries. Moving on, you will see how connection pooling, caching, partitioning, and replication will help you handle increasing database workloads.
    
32. 
    
33. Achieving high database performance is not easy, but you can learn it by using the right guide—PostgreSQL 9.6 High Performance.
    
34. 
    
35. Style and approach
    
36. This book has been organized in such a manner that will help you understand basic PostgreSQL 9.6 performance tuning to advanced-level configuration. There are many real-world problems explained in this book and explained in clear language, because improving database performance requires an equal mix of understanding theoretical concepts and working through hands-on examples.
    
37. 
    
38. Contents
    
39. Chapter 1: PostgreSQL Versions
    
40. Chapter 2: Database Hardware
    
41. Chapter 3: Database Hardware Benchmarking
    
42. Chapter 4: Disk Setup
    
43. Chapter 5: Memory for Database Caching
    
44. Chapter 6: Server Configuration Tuning
    
45. Chapter 7: Routine Maintenance
    
46. Chapter 8: Database Benchmarking
    
47. Chapter 9: Database Indexing
    
48. Chapter 10: Query Optimization
    
49. Chapter 11: Database Activity and Statistics
    
50. Chapter 12: Monitoring and Trending
    
51. Chapter 13: Pooling and Caching
    
52. Chapter 14: Scaling with Replication
    
53. Chapter 15: Partitioning Data
    
54. Chapter 16 : Database Profiling
    
55. Chapter 17: Avoiding Common Problems
    
56. Chapter 18: Performance Features by

复制代码

本帖隐藏的内容

PostgreSQL 9 6 High Performance.pdf (21.09 MB, 需要: 5 个论坛币)

2017-7-26 06:54:17 上传

需要: 5 个论坛币  [购买]

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：performance PostgreSQL Performan Perform FORMA

谢谢分享

Your UNIX/Linux: The Ultimate Guide

谢谢！

好书好书

谢谢            

最新资料，很好啊。

呵呵呵呵呵

过来看一看