Replacing Oracle Features in PostgreSQL: HA, Functions & Extensibility

on YouTube ↗01h 09m

" summary

Shows concrete replacements and proven results: 20+ Oracle→Postgres migrations, schema conversion with ora2pg and AWS DMS, and demos of running concurrent REFRESH MATERIALIZED VIEW with pg_cron to avoid blocking. Replaces virtual columns with generated stored columns, implements flashback-like temporal tables via an extension, and uses PG_PARTMAN for automated partition maintenance — a 5 TB table with 1,000+ subpartitions and 16 TB HNSW index drops a query from ~24s to ~100ms. Covers Patroni, logical vs physical replication, Aurora/DSQL options, and pgvector (15,000+ GitHub stars).

AI-written summary · about

" chapters (10)

1. 0:00Introduction
2. 8:30Oracle vs PostgreSQL architecture
3. 14:34Materialized views & virtual columns
4. 22:29Time travel & flashback queries
5. 29:11Partitioning strategies
6. 34:46High availability solutions
7. 47:49Global & distributed PostgreSQL
8. 56:39PostgreSQL extensions
9. 1:02:00Migration strategies & tools
10. 1:04:28PostgreSQL & Oracle future

" related talks

• 31mSimplifying the Top Complexities While Migrating From Oracle to PostgreSQLAvinash Vallarapu · Percona Live 2022
• 06mMigration Consideration Oracle to PostgreSQLNeeta Goel · PGConf India 2025
• 46mThe Top 10 Mistakes When Migrating Oracle Databases to PostgreSQLJim Mlodgenski · Percona Live 2022
• 29mTales from the Field - Oracle to PostgreSQL migrationsAdithya Kumaranchath · POSETTE: An Event for Postgres 2024
• 51mOracle to PostgreSQL Migration with Near Zero DowntimeSumit Aneja, Vinay Kamble · Percona Live 2022
• 49mSELECT 'amazing features' FROM "postgresql"Kevin Davin · Voxxed Days Brussels 2024
• 51mWhen Postgres Can't, You Can!Keith Fiske · PostgresOpen 2013
• 51mHow Postgres is Different (read BETTER than) your databaseGurjeet Singh · PostgresOpen 2013