Chandra Pathivada
Amazon , DB Specialist Solutions Architect
San Francisco, California, United States
Actions
Chandra Pathivada is a Senior Database Specialist Solutions Architect with Amazon Web Services. He works with AWS RDS team, focusing on Opensource database engines like RDS PostgreSQL and Aurora PostgreSQL and Babelfish for Aurora PostgreSQL. He enjoys working with customers to help design, deploy, and optimize relational database workloads on AWS
Area of Expertise
Topics
PostgreSQL Monitoring & Health Checks: Ensuring Optimal Performance and Stability
Effective PostgreSQL monitoring and health checks are critical for maintaining database performance, stability, and availability. This session will explore key strategies, tools, and best practices for proactively monitoring PostgreSQL databases. We will cover essential health check parameters, including query performance, indexing efficiency, connection management, and resource utilization.
Attendees will learn how to leverage built-in PostgreSQL tools such as pg_stat_activity, pg_stat_statements, and EXPLAIN ANALYZE, alongside powerful external monitoring solutions like pgBadger and PGCollector.
Why PostgreSQL Isn't Utilizing Indexes: Diagnosing and Solving Performance Issues
In this session, we delve into the common scenarios where PostgreSQL may not be utilizing indexes as expected, leading to suboptimal query performance. We explore the underlying reasons, such as query optimization, data distribution, and indexing strategies, that can impact index usage. Join us as we discuss practical solutions and best practices for diagnosing and rectifying these issues, ultimately improving the efficiency of your PostgreSQL database. Whether you're a database administrator, developer, or simply interested in database performance, this session provides valuable insights into maximizing the benefits of indexing in PostgreSQL.
Seamless Transition: Migrating from Commercial to Open Source Databases
Join this session if you want to learn how to move your SQL Server databases to the cloud. Migrating expensive legacy databases can be time-consuming and resource-intensive. In this session, learn how Babelfish, a new translation capability, enables Amazon Aurora to understand commands written for SQL Server applications. Babelfish can help reduce migration time and the risks of your migration from SQL Server, and you can leave expensive licenses behind to start innovating with Amazon Aurora PostgreSQL-Compatible Edition. Also, discover how you can optimize your migration to take advantage of the performance and scalability benefits Amazon Aurora offers
PostgreSQL for SQL Server DBAs
Leverage your SQL Server skills to learn PostgreSQL through finding its commonalities and differences
Heterogenous Migration Techniques
Learn methods and techniques available for heterogenous migrations. This session contains practical 5 methods to migrate data from SQL Server to PostgreSQL
3 Steps to Migrate and Modernize SQL Server workloads to PostgreSQL.
Learn how to migrate SQL Server workloads to Babelfish for Aurora PostgreSQL in 3 steps.
"Mastering PostgreSQL: Advanced Techniques for SQL Server DBAs"
Unlock the full potential of PostgreSQL with our advanced session tailored specifically for SQL Server DBAs. This intensive session dives deep into PostgreSQL's robust features, exploring performance tuning, advanced indexing, replication, and more. Designed for database administrators familiar with SQL Server, this session will bridge the gap between the two platforms, equipping you with the skills to manage and optimize PostgreSQL databases effectively. Join us to enhance your expertise and ensure a smooth transition to leveraging PostgreSQL in your environment.
Amazon Babelfish for Aurora
Now the Babelfish for Aurora is available. This presentation is about how Babelfish helps customers to migrate SQL Server workloads to Postgres. In this presentation, we are going to give a demo of what is Babelfish , the internals of Aurora ,Aurora for SQL Server DBAs using Babelfish, and Labs on Application Migration.
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top