Replacing Oracle’s Advanced Features in PostgreSQL: High Availability, Advanced Functions, and Extensibility
Presented by:
Sameer Malik
Sameer Malik has been working on relational Databases for over 20 years now and is currently working as a Principal Database Solution Architect at AWS focused on RDS and Aurora. Sameer Malik has helped several customers with their migration journey from on-premise commercial Databases to the Open Source Databases such as PostgreSQL. Previous experience includes 1. Working at AWS for more than 6 years as Principal Product Manager and Principal Database Specialist Solution Architecture on RDS/Aurora. 2. Working at Google cloud as Principal Solution Engineer at Google Cloud focused on Cloud SQL for PostgreSQL and AlloyDB for PostgreSQL. 3. Working at Oracle corporation as Principal Exadata Sales Consultant,Principal Advanced Support Engineer at Oracle ACS (platinum support) and led the Performance tuning team for Oracle RAC and Exadata 4. working as a consultant focused on Oracle Database troubleshooting/performance tuning and DBA lead on several consulting companies like DTCC and Equifax.
No video of the event yet, sorry!
Migrating from Oracle to PostgreSQL often raises questions about replacing powerful Oracle features like Materialized Views, Flashback Queries, Virtual Columns, Oracle RAC, and PL/SQL Packages. While PostgreSQL doesn’t replicate these features identically, it offers robust alternatives that meet—and often exceed—Oracle’s capabilities. This session will guide you through: - Replacing Oracle’s Materialized Views, Virtual Columns, and Flashback Queries using PostgreSQL-native tools and techniques. - Implementing PostgreSQL’s high availability and disaster recovery solutions as alternatives to Oracle RAC and Data Guard. - Leveraging PostgreSQL’s extensibility with powerful extensions like PostGIS, pg_partman, and pg_cron to replicate and enhance Oracle package functionality. Through practical demonstrations and real-world migration examples, you’ll learn strategies, best practices, and tips to successfully translate Oracle’s advanced features into PostgreSQL solutions, empowering you to run mission-critical applications with confidence.
- Date:
- Duration:
- 50 min
- Room:
- Conference:
- Postgres Conference: 2026
- Language:
- Track:
- Dev
- Difficulty: