Presented by:

Vivek Singh is a Principal Database Specialist with AWS focusing on Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL engines. He works with enterprise customers providing technical assistance on PostgreSQL operational performance and sharing database best practices. He has over 17 years of experience in open source database solutions, and enjoys working with customers to help design, deploy, and optimize relational database workloads on AWS.

No video of the event yet, sorry!

PostgreSQL 17 and 18 represent significant milestones in the evolution of this robust open-source database system. PostgreSQL 17 introduces groundbreaking features including MERGE command enhancements, improved logical replication performance, and advanced row-level security capabilities. Notable additions include the implementation of SQL/JSON constructors, parallel query improvements, and enhanced UNIQUE constraints with NULLS NOT DISTINCT semantics.

The anticipated PostgreSQL 18 aims to further revolutionize database management with projected features like improved query parallelization, enhanced JSON functionality, and more sophisticated partitioning capabilities. Key highlights include the introduction of columnar storage options, advanced compression techniques, and enhanced support for distributed databases.

Both versions demonstrate PostgreSQL's commitment to performance optimization, scalability, and modern data handling requirements, while maintaining backward compatibility and the robust security framework that users have come to expect from this enterprise-grade database system.

Date:
2025 April 5 14:00 CDT
Duration:
50 min
Room:
73
Conference:
PgSaturday: Dallas 2025
Language:
Track:
Ops
Difficulty:
Medium