Finalmente, depois de um longo período sai a tão esperada versão do Postgres. Entre as principais mudanças:
*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
Para uma explicação mais detalhada de cada tópico: