Sharding Postgres with Basic tier in Hyperscale (Citus), how why and when

Sharding Postgres with Basic tier in Hyperscale (Citus), how why and when(techcommunity.microsoft.com)

2 points by onderkalaci 5 years ago | 3 comments

Is it difficult to migrate an existing database to Citus? In my project I designed the database so that each table includes a tenantId - so in this regard I'm well prepared I guess.

onderkalaci 5 years ago | |

As far as I can tell, considering that you are planning to migrate a multi-tenant application, you are pretty much ready to go. One step you should be careful is to make sure that all your queries include the tenantId filter.

There is a step-by-step documentation for migrating multi-tenant apps to Citus, which might help you to decide how much ready you are for a migration: https://docs.citusdata.com/en/latest/develop/migration.html#...

(p.s. I'm the author of the post)