官术网_书友最值得收藏!

Summary

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.
主站蜘蛛池模板: 玉田县| 通山县| 汶川县| 孝昌县| 田阳县| 蒙阴县| 玛曲县| 靖远县| 林芝县| 翁源县| 抚顺县| 眉山市| 宁化县| 青龙| 雅安市| 图们市| 富源县| 瓦房店市| 华亭县| 衡阳市| 山东| 和林格尔县| 宁乡县| 伊宁县| 商都县| 宣城市| 静安区| 江西省| 云和县| 信丰县| 宿迁市| 安丘市| 萍乡市| 吕梁市| 磐石市| 教育| 延长县| 塔河县| 黄梅县| 凤城市| 陇南市|