Presented by:

8bd3f4ce2015f4a73bdcc0684cef0e65

Swanand kshirsagar

Amazon Web Services (AWS)

Swanand is an Architect at AWS, where he has been part of the Professional Services team since 2018. With over 17 years of experience in database administration and design, His expertise primarily lies in PostgreSQL, alongside a deep knowledge of MySQL, SQL Server, and Oracle technologies.

At AWS, He has played a pivotal role in supporting large-scale customer migrations to AWS RDS and Aurora PostgreSQL, often guiding the transition from on-premises and other public cloud platforms. His focus has been on enhancing database performance and promoting the adoption of open-source database engines.

No video of the event yet, sorry!
Download the Slides

PostgreSQL is renowned for its extensibility and robust database management capabilities, making it a preferred choice for modern applications. This session, "Beyond the Basics: Exploring PostgreSQL Catalogs and Extensions," dives deep into the advanced features that elevate PostgreSQL from a traditional relational database to a powerful platform for diverse workloads.

We will explore PostgreSQL's system catalogs, which serve as the internal backbone for metadata storage, enabling dynamic schema management, query optimization, and fine-grained control over database operations. Alongside, we will discuss extensions—the modular building blocks that allow users to tailor PostgreSQL for specific use cases. From enhancing full-text search to integrating geospatial capabilities with PostGIS, we’ll showcase how extensions unlock unprecedented possibilities.

This talk is ideal for database architects, developers, and administrators looking to expand their understanding of PostgreSQL's inner workings and leverage its ecosystem to deliver innovative solutions. Attendees will leave equipped with practical insights into harnessing catalogs for database tuning and using extensions to push the boundaries of PostgreSQL’s functionality.

Date:
2025 March 20 14:30 EDT
Duration:
50 min
Room:
Gold Coast 3&4
Conference:
Postgres Conference 2025
Language:
Track:
Essentials
Difficulty:
Medium