Vivek Singh
Principal Database Specialist PostgreSQL at AWS
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.
Upcoming presentations
Migrating Oracle RAC to PostgreSQL Using Ora2Pg
Strategies, Challenges, and Best Practices
Migrating enterprise workloads from Oracle to PostgreSQL is becoming increasingly strategic as organizations pursue open-source innovation, cost optimization, and cloud modernization. This session delivers a practical, end-to-end view of the Oracle-to-PostgreSQL migration journey—from initial assessment and phased migration planning to tool selection and hands-on execution. Attendees will explo...
Autonomous PostgreSQL: When AI Agents Become Your DBA
Automating Health Checks, Parameter Tuning, and Index Management with MCP Servers and pgvector
PostgreSQL operations are evolving from reactive monitoring to autonomous, AI-powered management. Drawing from my experience with dozens of customers at AWS, this session demonstrates how agentic AI leveraging MCP servers can automate routine DBA tasks: running comprehensive health checks, tuning database parameters based on workload patterns, and identifying and removing duplicate or unused in...
The Elephant in the Room: Tackling PostgreSQL Major Version Upgrades Head-On
A Complete Guide to Planning, Testing, and Executing PostgreSQL Upgrades
PostgreSQL major version upgrades remain a critical challenge many organizations postpone until deadlines force action. This session confronts upgrade anxiety head-on by examining proven strategies including in-place upgrades, Blue/Green deployments, and logical replication approaches. Drawing from my experience with hundreds of customers at AWS, we'll explore upgrade options with their trade-o...
Past presentations
PostgreSQL 17 & 18: The Ground-Breaking Features You Can't Ignore
Unleashing Next-Gen Database Innovation: A Deep Dive into PostgreSQL's Revolutionary 17 & 18 Releases
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 enh...
Apr 5 2025
Navigating PostgreSQL End of Life: Upgrade Strategies and Best Practices
Explore PostgreSQL End of Life policies, upgrade options and strategies, pre- and post-upgrade steps, Aurora/RDS PostgreSQL upgrade strategies, and new features of PostgreSQL 16.
As PostgreSQL major versions reach End of Life annually, database administrators face critical upgrade decisions. This session provides a comprehensive guide to navigating PostgreSQL end-of-life scenarios and executing seamless upgrades. We'll explore proven strategies, best practices, and techniques for minimizing downtime during transitions for community PostgreSQL as well as Amazon Aurora an...
From Text to Meaning: pgvector Revolutionizes PostgreSQL Search
Learn about pgvector capabilities to enhance your semantic search
Dive into the cutting-edge world of semantic search with pgvector, the game-changing extension for PostgreSQL. This session explores how pgvector transforms traditional text-based queries into powerful, meaning-driven searches. Learn to harness vector embeddings to capture the essence of your data, enabling nuanced similarity comparisons and context-aware results. We'll demonstrate practical im...
End Of Life Is not the End: Fearless PostgreSQL Upgrades
Learn about PostgreSQL end-of-life policies, and best operational practices to deal with it.
PostgreSQL End of Life (EOL) policy ensures database performance and feature improvements, but presents challenges for users navigating upgrades. Ignoring EOL deadlines can expose organizations to security vulnerabilities, performance degradation, and compliance risks. This session provides a comprehensive guide to navigating PostgreSQL upgrades with confidence. We will delve into the potential...