Join us for a comprehensive exploration of PostgreSQL 18's most impactful features transforming database performance and developer workflows.

Asynchronous I/O: Discover the new AIO subsystem delivering up to 3x performance improvements. Learn to configure io_method options (sync, worker, io_uring) for optimal I/O performance.

Skip Scan: Explore the breakthrough that eliminates the "left-most column" limitation for multicolumn B-tree indexes. Queries can now efficiently use indexes even when leading columns are omitted—a game-changer for analytics workloads.

RETURNING Enhancements: Master OLD and NEW aliases for tracking before-and-after values in a single operation. See practical examples of building audit trails without triggers and sophisticated MERGE RETURNING workflows.

Generated Column Replication: Learn about the new publish_generated_columns parameter for replicating calculated values across distributed architectures, plus enhanced conflict monitoring with pg_stat_subscription_stats.

Key Takeaways:

- Configure AIO for maximum performance gains

- Consolidate indexes and accelerate queries with skip scan

- Implement atomic change tracking with RETURNING

- Enable generated column replication in distributed systems Don't miss this opportunity to gain practical, hands-on knowledge from real-world examples and expert insights.

Whether you're planning your PostgreSQL 18 upgrade or exploring its capabilities, this session will equip you with the skills to immediately apply these powerful features in your environment. 

Watch this session on-demand to learn more today!