Partitioning strategy for Oracle to PostgreSQL migrations on Azure | Citus Con 2023

Описание: Video of a conference talk about Oracle and PostgreSQL partitioning, delivered at Citus Con: An Event for Postgres 2023 by Adithya Kumaranchath. This talk explores tools and extensions you can use to migrate partitions from Oracle to PostgreSQL, and also discusses partitioning strategies compared to Oracle—and how you can choose amongst the alternatives. Oracle to PostgreSQL is one of the most common database migrations in recent times. For numerous reasons, we have seen several companies migrate their Oracle workloads to PostgreSQL, both in VMs or to Azure Database for PostgreSQL.

Table partitioning is a critical concept to achieve response times and SLAs with PostgreSQL. While a few open-source and third-party tools migrate the table schema and packages, there are not out-of-the-box tools that migrate partitions. So, partitioning strategy has become a very important topic for migration. As part of the migration, it is very important to have a good partitioning strategy due to the difference between Oracle and PostgreSQL. A bad partitioning strategy can lead to bloating and the vacuuming can take time.

Adithya Kumaranchath joined Microsoft 10 years ago. He is currently an Engineering Architect in Azure Data. He has been working with customers to solve complex data migration and engineering problems. Adithya’s passion for programming has kept him close to the leading-edge tech and has contributed to several ideas, architecture patterns, and methodologies that are used by many teams inside and outside of Microsoft.

► Video bookmarks:
⏩ 00:00 Introduction
⏩ 06:15 Oracle vs Postgres partitioning
⏩ 08:01 Steps to migrate partitioned tables
⏩ 12:14 Demo of migration end-to-end
⏩ 22:30 Important Resources (find in slides linked below)

✅ Learn more:
Watch more Citus Con 2023 talks: https://aka.ms/cituscon-playlist

📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: https://aka.ms/cituscon

📌 Let’s connect:  
Twitter – @CitusCon,   / cituscon  

More resources:
📣 Slides for this talk: https://speakerdeck.com/azuredbpostgr...

#CitusCon #PostgreSQL #Azure