Chirag Dave

Recent PostgreSQL releases introduced transformative capabilities for logical replication and partitioning, including filtering, parallel apply, sequence replication, and improved planning for partition-heavy workloads. These features are powerful, but tuning them for a specific environment remains complex.

AI-powered database intelligence can surface recommendations for Aurora performance issues, but acting on those recommendations safely in production requires governance. In this session, build a governed recommendation-to-remediation workflow for Aurora PostgreSQL.

This talk explores PostgreSQL's built-in statistics collection system, focusing on the powerful pg_stat_* views. You will learn how to use these views to gain insights into I/O patterns, query execution behavior, and overall resource utilization.

In this hands-on workshop, discover how to leverage generative AI to transform PostgreSQL database management through an integrated solution combining incident detection and response (IDR) with the Model Context Protocol (MCP) for performance optimization.

Navigating PostgreSQL major version upgrades in Amazon Aurora PostgreSQL-Compatible Edition and Amazon RDS for PostgreSQL environments requires careful planning and understanding of available options. This session provides a comprehensive guide to upgrade paths, covering both in-place and replication-based strategies.

This comprehensive guide explores PostgreSQL's built-in statistics collection system, focusing on the powerful pg_stat views. Learn how to leverage these views to gain deep insights into database performance, including I/O patterns, query execution statistics, and resource utilization.

This presentation explores the various options for running PostgreSQL on AWS, with a specific focus on open-source advanced driver technologies and their role in reducing downtime.

Do you deal with PostgreSQL query performance–related issues? In this code talk, explore advanced techniques for monitoring query plans in Amazon Aurora PostgreSQL-Compatible Edition and maintaining query plan stability using Aurora query plan management.

Partitioning divides table into smaller parts which helps in improving database performance and scalability. In PostgreSQL there not so obvious reason why you want to partition your table effectively to improve scalability, optimize the performance and management of your database.

In this chalk talk, learn how you can deploy an Amazon Elastic Kubernetes Service (Amazon EKS) cluster, create an Amazon Aurora and Amazon RDS DB cluster, and integrate them into your workflows to deploy a microservices application.

Aurora Serverless v2 is an on-demand, autoscaling configuration for Amazon Aurora. In this talk you will get to know the fundamentals/scaling principles of Serverless v2.

Kubernetes is a portable, extensible, open-source platform for managing containerized workloads and services. Using the AWS Controller for Kubernetes (ACK) interface, you are able use AWS services directly from Kubernetes.

At AWS, we like to say that security is always job #1. Since Amazon Aurora and Amazon RDS are fully managed, AWS takes care of key security tasks like patching, isolation and security, and more.

In this workshop, learn to deploy a continuous integration and delivery (CI/CD) workflow using GitOps and the AWS Controllers for Kubernetes (ACK) service controller for Amazon RDS on Amazon EKS to create and manage Amazon Aurora Serverless v2 databases effectively. GitOps relies on Git as the single source of truth for declaratively managing containerized infrastructure and application...

In this chalk talk, learn best practices for Amazon Aurora cost optimization. Gain a deeper understanding of the key Aurora cost dimensions, such as compute, storage, I/O, and backups, and discover what mechanisms and optimizations you can apply to reduce costs.

Amazon Relational Database Service (Amazon RDS) for PostgreSQL and for MySQL now support a new Amazon RDS Multi-AZ deployment option with one primary and two readable standby database (DB) instances across three Availability Zones (AZs).

Introduction to PostgreSQL extensions available to RDS PostgreSQL and Aurora PostgreSQL. This talk will highlight the use of aws_lambda, aws_s3.table_import_from_s3 and aws_s3.query_export_to_s3