- 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.
推薦閱讀
- Enhancing Microsoft Content Management Server with ASP.NET 2.0
- UG NX 12.0中文版完全自學一本通
- PS職場達人煉成記:人人都能學會的Photoshop辦公設計技巧
- 性能測試從零開始
- Apache OFBiz Development: The Beginner's Tutorial
- Photoshop后期強:數碼攝影后期完全寶典
- UG NX 9.0中文版 基礎教程 (UG工程師成才之路)
- CAD/CAM技術與應用
- 我為PS狂 Photoshop照片處理一分鐘秘笈
- 跟儲君老師學Excel極簡思維
- Excel 2016入門與提高
- 音樂日記:Logic Pro X場景x風格編曲實用教程
- iPhone Applications Tune/Up
- Photoshop+Adobe Camera Raw+Lightroom(攝影后期照片潤飾實戰)
- Photoshop CC 2017從入門到精通