Presented by:

Baji is a Sr. Database Engineer at Amazon Web Services. He focuses on enhancing database services, developing innovative solutions for complex customer scenarios, and helping customers with critical database challenges. He was also a Database Migration Expert who developed many successful database solutions addressing challenging business requirements for moving databases from on-premises Oracle and SQL Server to Amazon RDS and Amazon Aurora PostgreSQL/MySQL. He is an eminent author, having written several books on PostgreSQL. A few of his recent works include “ Procedural Programming with PostgreSQL PL/pgSQL” “ PostgreSQL Configuration,” “ Beginning PostgreSQL on the Cloud,” and “ PostgreSQL Development Essentials.” Furthermore, he has delivered several conference and workshop sessions.

Rajeshkumar Sabankar

amazon web services inc

Rajesh Kumar Sabankar is a Senior GTM Specialist SA, Databases, Startups with Amazon Web Services. He works with Amazon customers to design secure, scalable, cost efficient and resilient architectures in the AWS Cloud and helps customers perform migrations at scale.

Migrating from databases like Oracle to PostgreSQL presents unique scheduling challenges that can impact the automation of critical tasks such as maintenance, batch jobs, and data processing. This presentation will address these challenges, highlighting the differences in scheduling mechanisms and the complexities involved in adapting existing task workflows to PostgreSQL. We will explore the available scheduling options within PostgreSQL, focusing on the capabilities and best practices of using pg_cron and pg_dbms_job. Attendees will learn how to effectively manage scheduling tasks in PostgreSQL, ensuring a smooth transition and maintaining operational efficiency post-migration.

Date:
2024 November 7 10:40 PST
Duration:
50 min
Room:
Ops: 421
Conference:
Seattle 2024
Language:
Track:
Ops
Difficulty:
Medium