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.

D4380a244531c0d962f2c1c1720c05f8

abhinav sagar

CSG systems International

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.

B1f5a3ee6c839da34dff9803a6bfeb9f

Premnath Jangam

CSG Systems International

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