Boosting Typical Query Patterns: PostgreSQL 18's Performance Enhancements
October 21–24
As with previous releases, PostgreSQL 18 introduces many performance improvements that directly benefit everyday database tasks.
Beyond doing an overview of the performance improvements, this talk will go over these changes and compare the performance of popular applications using PostgreSQL 16, 17 and 18, to highlight the improvements in PG 18.
The optimizer now automatically eliminates unnecessary self-joins, converts IN (VALUES ...) to x = ANY ... for better statistics, and transforms OR-clauses into arrays for faster index processing. It also speeds up INTERSECT, EXCEPT, window aggregates, and optimizes SELECT DISTINCT and GROUP BY queries by reordering keys and ignoring redundant columns.
This talk will walk through these and many more, while showing data from running applications.