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

(techcommunity.microsoft.com)

2 pointsonderkalaci4y ago3 comments

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.

onderkalaciOP4y 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)

j / k navigate · click thread line to collapse

3 comments

I_am_tiberius4y ago

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.

onderkalaciOP4y ago

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

j / k navigate · click thread line to collapse