High concurrency workloads may see up to 2x better write throughput due to improvements with write-ahead log (WAL) processing. Additionally, the new streaming I/O interface speeds up sequential scans (reading all the data from a table) and how quickly ANALYZE can update planner statistics.
introduces a new internal memory structure for vacuum that consumes up to 20x less memory
improves the performance of queries with IN clauses that use B-tree indexes
includes several improvements for query planning, including optimizations for NOT NULL constraints, and improvements in processing common table expressions (WITH queries)
I'm truly excited for the vacuum improvements and the incremental backups. These are the biggest pain points I have with PostgreSQL at the moment and to stop relying on external programs and scripts to handle them is awesome!
gainz
Ugh. Not looking forward to the upgrade process, but excited for the performance bumps.
Wow, this is an impressive release!
I'm truly excited for the vacuum improvements and the incremental backups. These are the biggest pain points I have with PostgreSQL at the moment and to stop relying on external programs and scripts to handle them is awesome!