PostgreSQL 8.4 ist nun in der stable Version erhältlich. Die Entwickler geben als Neuerungen an:

• 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 (greatly reduces vacuum 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