From the Release Notes: Major enhancements in PostgreSQL 9.6 include: Parallel sequential scans, joins and aggregates Elimination of repetitive scanning of o

From the Release Notes: 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