首页 | 项目 | 资讯 | 专题 | 文档 | 服务 | 留言

PostgreSQL 8.2 Enters Beta

[URL:http://cosrc.cn/info/v.s/30] 作者:网友 | 出处:网络 | 2006-09-30 | 返回
拟在2006年11月于澳大利亚悉尼发布,主要更新(草稿,正式发布声明尚未公布)有以下几方面内容: 性能改进:8.2版在高端OLTP(在线事务处理)系统测试中全面提升性能约20%,数据仓库的用户提升的效率更多。改进包括更快的内存中及磁盘上的排序,更好的多处理器伸缩性,对表分区数据有更好的查询规划,对大量数据的导入速度更快以及大大提速的外部连接。 不中断运行的备份:通过对8.0版就增加的PITR功能(时间点恢复)的扩展,管理员现在能很方便地对用户的数据库进行备份(而不必中止服务器的运行)。 在线索引的创建:可以使OLTP和WEB应用程序即使是在表正在进行索引时也可以更新表的内容,这也减少或消除了停机时间。 SQL 2003标准兼容:PostgreSQL一直就以与SQL标准兼容性高而著称,这次新版本也增加了在ANSI SQL 2003标准中包括的功能,如:静态聚合,多行VALUE插入功能,UPDATE RETURNING (更新时返回更新记录)和多列聚合功能。 在8.2版中已提供且早于其他主流数据库系统的高级功能,包括: GIN索引:对半结构化和全文本数据内容(TEXT类型)提供一个更加灵活和可编程处理的索引方式。 DTrace(动态跟踪):PostgreSQL现已使用SUN公司的Solaris中所用的DTrace技术和其他高级跟踪工具监控系统。 其他还有一系列的新功能和改进均使得8.2版的数据库管理员工作起来更有效率,详情将会在正式发布时在新闻发布稿中提供。 下载地址: Linux Source 版: http://wwwmaster.postgresql.org/download/mirrors-ftp?file=source%2Fv8.2beta1%2Fpostgresql-8.2beta1.tar.gz (14.6MB) Windows binary版: http://wwwmaster.postgresql.org/download/mirrors-ftp?file=binary%2Fv8.2beta1%2Fwin32%2Fpostgresql-8.2beta1.zip (23.6MB) Beta Information Feature freeze for version 8.2 took place on August 1st, 2006. Since that time we have gone through the submitted patch queue and applied all outstanding patches that were deemed ready for release. As of this time, we are now releasing beta releases for all to test. What can you do to help? Take a backup of your current database system with both old and new versions of pg_dump and load them into 8.2. Any application you have that runs against a PostgreSQL database should be tested against the updated server. You can report any PostgreSQL bugs or errors using the bug reporting form. If your platform is not listed in the automatic build farm, please download the source code and verify that you can build the release. You can send positive or negative results to pgsql-hackers@postgresql.org. You might want to subscribe to the pgsql-hackers mailing list. This is where development of PostgreSQL takes place, and users involved in the beta program should be subscribed in order to recieve the most up to date information Some important links you will need for testing PostgreSQL 8.2 You can find the latest beta release at http://www.postgresql.org/ftp/source/v8.2beta1 You can find the latest beta win32 binaries at http://www.postgresql.org/ftp/binary/v8.2beta1/win32 The list of Open Items for 8.2 Release notes for 8.2 Developer version of the documentation