Tackling Scheduling Challenges with pg_cron and pg_dbms_job
Presented by:
BAJI SHAIK
Baji Shaik is a Sr. Lead Consultant with AWS ProServe, GCC AMER. He was introduced to databases in 2011 and over the years has worked with Oracle, PostgreSQL, Postgres Advance Server, RedShift, and Greenplum. His background spans a wide depth and breadth of expertise and experience in SQL/NoSQL database technologies. He is a Database Migration Expert and has developed many successful database solutions addressing challenging business requirements for moving databases from on-premises to Amazon RDS and Aurora PostgreSQL/MySQL and worked on tuning the RDS/Aurora PostgreSQL/MySQL databases to perform upto the mark. 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, workshop sessions and published many blogs in aws blog community.
Rajeshkumar Sabankar
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.
No video of the event yet, sorry!
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