Presented by:

Shayon Sanyal is a Principal Worldwide Specialist Solutions Architect at AWS, where he is the global subject matter expert for Amazon Aurora PostgreSQL and leads the Agentic AI for Databases initiative. He works with enterprises to take vector search, hybrid retrieval, and agentic AI systems from prototype to production scale, including some of the largest pgvector deployments in existence, with over 100 billion embeddings on PostgreSQL. He authored the launch blog for pgvector on Aurora PostgreSQL and co-authors AWS case studies on billion-scale retrieval. A regular speaker at re:Invent, PostgresConf, Postgres Summit, and PGConf.EU, Shayon is passionate about making PostgreSQL’s advanced capabilities accessible to the broader community.

Download the Slides

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:
2025 March 19 16:00 EDT
Duration:
50 min
Room:
Seminole B
Conference:
Postgres Conference 2025
Language:
Track:
Ops
Difficulty:
Medium