- PostgreSQL 9.0 High Performance
- Gregory Smith
- 210字
- 2021-04-13 16:58:45
PostgreSQL has come a long way in the last five years. After building solid database fundamentals, the many developers adding features across the globe have made significant strides in adding both new features and performance improvements in recent releases. The features added to the latest PostgreSQL 9.0, making replication and read scaling easier than ever before, are expected to further accelerate the types of applications the database is appropriate for.
- The extensive performance improvements in PostgreSQL 8.1 and 8.3 in particular shatter some earlier notions that the database server was slower than its main competitors.
- There are still some situations where PostgreSQL's feature set results in slower query processing than some of the commercial databases it might otherwise displace.
- If you're starting a new project using PostgreSQL, use the latest version possible (and strongly prefer to deploy 8.3 or later).
- PostgreSQL works well in many common database applications, but certainly there are applications, it's not the best choice for.
- Not everything you need to manage and optimize a PostgreSQL server will be included in a basic install. Be prepared to include some additional number of utilities that add features outside of what the core database aims to provide.
- Performance tuning is best approached as a systematic, carefully measured practice.
推薦閱讀
- Adobe創意大學After Effects CS5 產品專家認證標準教材
- Entity Framework Tutorial
- AI圖像處理:Photoshop+Firefly后期處理技術基礎與實戰
- Mastering phpMyAdmin 3.3.x for Effective MySQL Management
- 板繪教室:SAI零基礎日系動漫插畫入門教程
- 大規模組織DevOps實踐
- Drupal 6 Content Administration
- 中文版Dreamweaver基礎培訓教程
- 中文版After Effects 2022基礎教程
- AutoCAD 2016中文版基礎教程(全圖解視頻版)
- 3D打印輕松實踐:從材料應用到三維建模
- 社會調查數據管理:基于Stata 14管理CGSS數據
- Microsoft SQL Server 2008 High Availability
- jQuery 1.3 with PHP
- 選擇的藝術:Photoshop圖像處理深度剖析(第3版)