[–] sickpig 9y ago ↗ To have a look at what's new in 9.6 see: https://wiki.postgresql.org/wiki/Newin96Quick list of major features:Parallel sequential scans, joins and aggregatesElimination of repetitive scanning of old data by autovacuumSynchronous replication now allows multiple standby servers for increased reliabilityFull-text search for phrasesSupport for remote joins, sorts, and updates in postgres_fdwSubstantial performance improvements, especially in the area of improving scalability on many-CPU servers
1 comment
[ 2.5 ms ] story [ 9.9 ms ] threadQuick list of major features:
Parallel sequential scans, joins and aggregates
Elimination of repetitive scanning of old data by autovacuum
Synchronous replication now allows multiple standby servers for increased reliability
Full-text search for phrases
Support for remote joins, sorts, and updates in postgres_fdw
Substantial performance improvements, especially in the area of improving scalability on many-CPU servers