Performance Improvements in PostgreSQL 9.5, 9.6 and beyond

Date: 2016-09-14
Time: 18:30 - 19:20
Room: Ft. Worth 2
Level: Intermediate

Recent PostgreSQL releases bring plenty of new features, and a lot of them are related to performance - PostgreSQL 9.5 and 9.6 are not an exception - parallel queries, multiple improvements of sorting performance, hashjoin improvements, lock scalability, optimizer improvements, etc. This talk aims to present the main performance improvements along with benchmarks illustrating the gains.

I also plan to briefly talk about what may happen in the near future - what performance-related features the community are in the works.


Tomas Vondra