Bio
Suraj Kharage is a Senior Staff SDE I at EDB, specializing in database server development.
He plays a role in advancing the capabilities of EDB Postgres Advanced Server,
where he actively contributes to the design and implementation of proprietary features.
In addition to feature development, Suraj supports his team by diagnosing and fixing complex bugs,
ensuring stability in critical database components.
Talk Description:Unboxing Postgres 18: Features, Performance, and the Future of Scaling
PostgreSQL 18 marks a pivotal release, bringing fundamental changes that will redefine performance and scaling capabilities for enterprise users and application developers. This talk serves as an essential, practical guide for DBAs, developers, and architects
to explore the major advancements in the latest PostgreSQL version.
We will "unbox" Postgres 18 by diving deep into the most significant changes, moving beyond release notes to examine their real-world implications.Key
areas covered will include:
- Asynchronous I/O (AIO): We'll analyze how this fundamental change impacts disk latency, improves concurrency, and provides a significant boost to transaction
throughput, especially under high load scenarios.
- Query Optimization & Speed: An analysis of new features in the query planner, focusing on improvements to parallel processing, query rewrite capabilities,
and the impact of the latest statistics collection methods.
- Logical Replication & Scaling: Examination of new options for managing large-scale replication topologies, including enhancements for conflict resolution
and monitoring logical slots.
- Developer Experience: A look at new and improved SQL syntaxes.
- Smarter & Faster Upgrades: Upgrading major versions is now much less disruptive.
- Security and Management: Overview of new authentication method.
Attendees will leave with a clear roadmap for adopting PostgreSQL 18 and understanding the most impactful new features for their systems.