Post Content
Follow proven strategies for migrating multi-terabyte Oracle databases to PostgreSQL with minimal downtime. Adithya Kumaranchath (Microsoft) shares approaches in his talk “Migrating VLDBs from Oracle to Azure Database for PostgreSQL” at POSETTE: An Event for Postgres 2026. Abstract: Migrating very large databases (VLDBs) to PostgreSQL becomes significantly more complex when the target is a managed cloud service. This session presents proven, field‑tested strategies for migrating multi‑terabyte Oracle workloads to Azure Database for PostgreSQL – Flexible Server with minimal downtime and predictable performance.
We’ll cover the full migration lifecycle: validating schema compatibility, planning WAL throughput and storage layout, optimizing network and bulk‑load operations, and using logical replication to achieve near‑zero‑downtime cutovers. You’ll learn practical techniques for handling partitions, large objects, and long‑running transactions at scale, along with methods to avoid common VLDB pitfalls such as bloat, autovacuum stalls, slow COPY performance, and resource throttling caused by misaligned compute or IOPS.
Real customer examples will highlight what works, what to avoid, and how to design stable, high‑performance deployments from day one. You will leave with a repeatable VLDB migration checklist and tuning templates ready for immediate use.
Adithya Kumaranchath is an architect, programmer, gamer, speaker and works at Microsoft. Currently his focus is migrations to Azure data services.
► Video chapters:
⏩ 00:00 – Music & introduction
⏩ 01:04 – The problem of large database migration
⏩ 02:02 – Why customers choose PostgreSQL
⏩ 03:54 – Key challenges in VLDB migration
⏩ 09:00 – Customer case study: oracle to PostgreSQL
⏩ 15:40 – VLDB migration lifecycle, process, & tool recommendations
⏩ 19:02 – Advanced considerations: complexity, scale, & time
⏩ 21:46 – Common pitfalls and optimization strategies
⏩ 24:20 – Closing remarks and resources
📕 Everything you need to know about POSETTE: An Event for Postgres can be found at: https://posetteconf.com
✅ Learn more: watch more POSETTE talks: https://aka.ms/posette-playlist
📌 Let’s connect:
LinkedIn: https://www.linkedin.com/company/posetteconf/
X – @PosetteConf, https://x.com/PosetteConf
Mastodon – @posetteconf, https://mastodon.social/@posetteconf
Bluesky – @posetteconf.com, https://aka.ms/posette-on-bluesky
Microsoft for Postgres LinkedIn: https://www.linkedin.com/company/microsoft-for-postgresql
#PosetteConf #PostgreSQL #Azure Read More Microsoft Developer
