Migrating from Oracle PL/SQL to PostgreSQL PL/pgSQL : Navigating Differences and Optimization Challenges.
Presented by:
As a Database Administrator and Developer having 5 years experience in administrative activities like Installation , Configuring backups and I'm also passionate about automating administrative tasks , learning new technologies and also implemented backend technologies like Python and Java. With PostgreSQL Development I've had opportunity using wonders of Python while handling data , implementing multi-threading options and also helped me for few automations as required from PostgreSQL Development perspective.

abhinav sagar
I am Abhinav having more than 10 years of experience in database administration and enthusiastic on learning and researching new things in the database technologies and passionate about participating in the technical presentations.

Premnath Jangam
I am a database administrator with 8 years of experience in Postgres. Has a fashion of Researching and presenting the talks on wider community of postgres.
No video of the event yet, sorry!
In today’s rapidly evolving technology landscape, PostgreSQL has emerged as a popular choice for organizations seeking to leverage the power of open-source databases while maintaining scalability, performance, and flexibility. As enterprises migrate from proprietary database systems like Oracle to PostgreSQL, developers face the challenge of adapting existing PL/SQL codebases to PL/pgSQL. Despite the similarities between these two procedural languages, significant differences in their syntax, performance characteristics, and ecosystem features require a thoughtful approach to migration and optimization. This session will focus on highlighting the key differences between Oracle’s PL/SQL and PostgreSQL’s PL/pgSQL, providing actionable insights on how to efficiently navigate these differences during migration. A deep dive will be taken into critical areas including compilation methodology, Code Debugging , Exception Handling, work_mem , Bulk Load and more.
- Date:
- 2025 March 21 10:30 EDT
- Duration:
- 50 min
- Room:
- Gold Coast 1&2
- Conference:
- Postgres Conference 2025
- Language:
- Track:
- Dev
- Difficulty:
- Medium