Webinar: Hands on Postgres 17: What’s New & How It Impacts Performance
Dive deep into the final release, examining what features have been included, what was removed in the beta phase due to bugs that were found, and how the changes in this release will impact your database performance and monitoring.
Lukas Fittl
Founder & CEO, pganalyze
Founder & CEO, pganalyze
In detail, we walk through
- How faster B-tree scans and adaptive vacuum strategies improve performance
- The introduction of streaming I/O, and when to tune the new “io_combine_limit”
- Configurable SLRU cache sizes for better support for running Postgres at large scale
- Updated pg_stat_checkpointer and pg_stat_bgwriter views for in-depth monitoring
- The impact of built-in C.UTF-8 locale support for better compatibility after OS upgrades
- Changes to the Postgres planner, such as CTE statistics propagation, better handling of IN lists in joined tables and more
- Improvements to the EXPLAIN command (such as the new SERIALIZE option), to help you optimize queries better
- A quick overview of other significant improvements (Incremental backups, logical replication, COPY ON_ERROR, JSON_TABLE & more)
Watch the Webinar Recording
Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze
