Comment Comment by melor From the Release Notes:Major enhancements in PostgreSQL 9.6 include: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 parent melor 10 years ago
Major enhancements in PostgreSQL 9.6 include:
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