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

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.
主站蜘蛛池模板: 澳门| 澳门| 玛曲县| 长沙市| 义马市| 哈巴河县| 宜城市| 子长县| 嘉兴市| 措勤县| 天镇县| 彭泽县| 尼玛县| 镇沅| 怀来县| 临西县| 寿宁县| 衡东县| 大冶市| 扎兰屯市| 泰来县| 沂源县| 星子县| 北安市| 盐山县| 肃南| 区。| 高淳县| 瓦房店市| 德清县| 文安县| 麟游县| 汝阳县| 庐江县| 扶风县| 丹东市| 类乌齐县| 泉州市| 叶城县| 上蔡县| 城市|