PostgreSQL 8.3.0

Since the release of the previous non-bugfix version of PostgreSQL (8.2), a little more than a year has passed, and the official blog already writes “Watch for 8.3 this week!”.



Well, it seems, waited; although the site has not yet been announced (upd: now announced ), but you can already download the source code for the new version 8.3.0 , and even the Windows binaries .



A swing is worth it. According to Release notes , a lot of tasty things appeared in PostgreSQL 8.3:

• The good old full-text search tsearch2 is now part of the PostgreSQL language, not a contrib module;
• The SQL / XML standard is supported, and the XML data type appeared;
• The long-awaited enumerations (data types) appeared - ENUM;
• It has become possible to make arrays of composite types;
• A data type UUID (from itself: I literally wanted to use it yesterday ...) and the corresponding functions for its creation appeared;
• Now when sorting you can choose, NULL values ​​will appear in front of or behind significant values;
• The values ​​for the current cursor can now be modified and even deleted;
• Server settings can now be changed for individual functions;
• User-created data types can now have modifiers;
• Cached queries can now automatically reschedule if the statistics of a table or its structure have changed significantly;
• ... and in general, both journaling and statistics calculation have significantly improved;
• It has become possible to use SSPI for authentication under Windows;
• Autovacuum is now enabled by default and can now run on multiple processes at the same time to improve performance;
• The Windows version of PostgreSQL can now be built using MS Visual C ++.

')

... And also, of course, a considerable number of bug fixes and performance optimizations. We are waiting for interesting benchmarks :)