The PostgreSQL project released the first beta for PostgreSQL 8.2 for widespread testing on Monday. According to PostgreSQL core team member Josh Berkus, the 8.2 beta includes a number of new features, better support for the American National Standards Institute (ANSI) SQL:2003 standard, and numerous performance improvements.
Berkus says that PostgreSQL 8.2 will improve performance "around 20% overall" for high-end online transaction processing (OLTP) systems, and include "even larger gains in data warehousing efficiency."
The changes in this release include "faster in-memory and on-disk sorting, better multi-processor scaling, better planning of partitioned data queries, faster bulk loads, and vastly accelerated outer joins."
Лично для меня важна поддержка utf8 в TSearch2