Anita Singh
Principal Specialist Solutions Architect at AWS
Anita Singh brings over two decades of experience architecting database solutions for mission-critical applications across diverse industries and technologies. For the past 5+ years at AWS, she has specialized in accelerating PostgreSQL adoption—particularly migrations from Oracle and SQL Server to PostgreSQL. She thrives in customer-focused environments, combining strong analytical capabilities with interpersonal skills to navigate complex technical challenges while inspiring teams to achieve their best.
Upcoming presentations
why PostgreSQL Is Slow (And What to Do About It)
When PostgreSQL performs poorly, the root cause is rarely a single configuration setting. This talk breaks down the most common causes of performance issues — missing or ineffective indexes, partitioning, parallelism, poor statistics, suboptimal query patterns, and misinterpreted EXPLAIN plans. Attendees will learn how to diagnose problems s...
RDS Maintenance: Strategies for Patching and Version Upgrades
Postgresql Upgrade on AWS
As PostgreSQL continues to evolve with annual major releases and regular security patches, database administrators face the critical challenge of maintaining up-to-date RDS PostgreSQL instances while minimizing operational disruption. This paper presents a comprehensive analysis of patching strategies and engine upgrade methodologies for Amazon RDS PostgreSQL, examining the trade-offs between d...
PostgreSQL Statistics Unleashed: Mastering Query Optimization Through Data-Driven Insights
Database Statistics in PostgreSQL: What the Query Planner Knows and How It Decides
Understanding Database Statistics in PostgreSQL
Database statistics are the secret weapon behind PostgreSQL's query optimizer, directly impacting query performance and overall database health. This session takes you beyond the basics to explore how PostgreSQL collects, maintains, and leverages statistics to make intelligent decisions about query execution.
Whether you're managing a handfu...
Past presentations
Database statistics play a crucial role in optimizing query performance and overall database health in Postgres. This session will provide an in-depth look at the different types of database statistics maintained by Postgres, how they are collected and used by the query optimizer, and techniques for monitoring and managing these statistics.
Additionally, the session will walkthrough on how ...
Mar 21 2025
Understanding Database Statistics in Postgres
Unlocking Insights for Performance Optimization
Extract: Understanding Database Statistics in PostgreSQL Understanding Database Statistics in Postgres Session Description Database statistics play a crucial role in optimizing query performance and overall database health in Postgres. This session will provide an in-depth look at the different types of database statistics maintained by Postgres, how they are collected and used by the qu...
Leveling Up Your PostgreSQL Game using Extensions
PostgreSQL extensions
PostgreSQL's rich ecosystem of extensions offers a wealth of opportunities to enhance database functionality and overcome performance limitations. In this session, we will explore a curated selection of noteworthy PostgreSQL extensions and showcase how they can be leveraged to optimize database operations, improve performance, and unlock advanced capabilities.
Participants will discover how ...
