Webinar Recording: Hands on Postgres 17: What’s New & How It Impacts Performance

Follow-up resources

• Presentation slides
• pganalyze newsletter

Streaming I/O references

• Streaming I/O, vectored I/O (WIP)
• 5mins of Postgres: Streaming I/O
• Streaming I/O in ANALYZE
• Streaming I/O in pg_prewarm
• AIO v2.0

Index scan references

• Enhance nbtree ScalarArrayOp execution
• 5mins of Postgres: Faster B-tree Index Scans
• CrunchyData Blog
• Benoit Tigeot's Blog
• Adding Skip Scan

VACUUM references

• 5mins of Postgres: Faster VACUUM with Adaptive Radix Trees
• Add template for adaptive radix tree
• The Adaptive Radix Tree
• Add TIDStore
• Use TidStore

Planner optimization references

• Extract column statistics from CTE references, if possible
• Add better handling of redundant IS [NOT] NULL quals
• Allow plan nodes with initPlans to be considered parallel-safe

EXPLAIN for query tuning references

• 5mins of Postgres: Improved EXPLAIN for SubPlan nodes
• EXPLAIN (ANALYZE, SERIALIZE)
• Add EXPLAIN (MEMORY) to report planner memory consumption

SLRU cache references

• Improve performance of subsystems on top of SLRU
• GitLab Blog
• Buttondown.com
• subtransaction_buffers
• 5mins of Postgres: Configurable SLRU cache sizes for increased performance

Monitoring improvement references

• 5mins of Postgres: The pg_stat_checkpointer view
• pg_stat_bgwriter

Additional references on noteworthy updates

• 5mins of Postgres: The new built-in C.UTF-8 locale
• 5mins of Postgres: Incremental Backups
• Logical Replication Failover
• Online Upgrading Logical and Physical Replication Nodes

Get in touch with us to learn more or request a demo