Episode
Partitioning strategy for Oracle to PostgreSQL migrations on Azure | Citus Con 2023
with Adithya Kumaranchath
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.
Recommended resources
- Watch more Citus Con 2023 talks
- Everything you need to know about Citus Con: An Event for Postgres 2023
- Star the GitHub repo for the Citus database extension, to show your support of Citus open source
Connect
- Citus Con An Event for Postgres | Twitter: @CitusCon
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.
Recommended resources
- Watch more Citus Con 2023 talks
- Everything you need to know about Citus Con: An Event for Postgres 2023
- Star the GitHub repo for the Citus database extension, to show your support of Citus open source
Connect
- Citus Con An Event for Postgres | Twitter: @CitusCon
Have feedback? Submit an issue here.