PostgreSQL 8.4 Released

PostgreSQL 8.4 released today

Major changes:
* Windowing Functions
* Common Table Expressions and Recursive Queries
* Default and variadic parameters for functions
* Parallel Restore
* Column Permissions
* Per-database locale settings
* Improved hash indexes
* Improved join performance for EXISTS and NOT EXISTS queries.
* Easier-to-use warm standby
* Automatic sizing of the Free Space Map
* Visibility Map (overhead for slowly changing tables)
* Version-aware psql (backslash commands work against older servers)
* Support SSL certificates for user authentication
* Per-function runtime statistics
* Easy editing of functions in psql
* New contrib modules: pg_stat_statements , auto_explain , citext , btree_gin

8.4 Release Notes , PostgreSQL 8.4 Feature List
')
UPD: Russian-speaking review on opennet.ru