02-05-2008, 11:03 AM
Quote:PostgreSQL is the first open source database to implement Synchronized Scan, which greatly reduces I/O for data mining. The Windows team has enabled Visual C++ compilation of PostgreSQL, improving stability and performance on Windows, as well as accessibility to the project to Windows contributors. New logging options have been added and the overhead of the statistics collector has been diminished in order to make it easier to monitor your servers.
Of course, this wouldn't be a proper PostgreSQL release without providing lots of new features for application developers, including:
* ANSI-standard SQL/XML support, including XML export
* Text search: our advanced full text search tool, TSearch2, has been merged into the core distribution with better management and new dictionaries and languages
* GSSAPI and SSPI authentication support
* New data types: UUIDs, ENUMs and arrays of composite types
"We process over 18,000 queries per second on over 300GB of user data on our PostgreSQL servers, and those numbers go up every month," said Gavin Roy, CTO of social networking site MyYearbook.com. "We're very excited about HOT, shared buffer scan improvements and integrated tsearch indexing. Preliminary testing shows that 8.3 will improve our database load profile while decreasing response times. We're really looking forward to it."
In addition to the many new core features, several new optional components have matured and released 1.0 versions during the 8.3 release cycle. These include SNMP support, horizontal scalability options such as PL/Proxy, pgPool-II, and Bucardo, a graphical debugger for stored procedures, and a scalable connection pooler called pgBouncer...
full announcement: http://www.postgresql.org/about/press/presskit83
release notes: http://www.postgresql.org/docs/8.3/stati...e-8-3.html
feature list: http://www.postgresql.org/about/press/features83
binary downloads: http://www.postgresql.org/ftp/binary/v8.3.0/