PostgreSQL 8.3.0

A little over a year has passed since the release of the previous non-bugfix version of PostgreSQL (8.2), and they already write “Watch for 8.3 this week!” On the official blog .

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

A worth the swing. According to Release notes , a lot of goodies appeared in PostgreSQL 8.3:

• The good old full-text search tsearch2 is now part of the PostgreSQL language, and not a contrib module;
• The SQL / XML standard is supported, and the XML data type has appeared;
• The long-awaited enumerations (data types) appeared - ENUM;
• It became possible to make arrays of composite types;
• A UUID data type appeared (from myself: I just wanted to use it just yesterday ...) and the corresponding functions for creating it;
• Now, when sorting, you can choose whether NULL values ​​will be shown in front of or behind significant values;
• 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 be automatically rescheduled if the table statistics or its structure has changed significantly;
• ... and in general, both logging and statistics calculation have improved significantly;
• It became possible to use SSPI for authentication under Windows;
• Autovacuum is now enabled by default and can now be run in 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 :)