3 ms·

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

• I_am_tiberius 5y 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.
  • onderkalaci 5y 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#migrating-an-existing-app https://docs.citusdata.com/en/latest/develop/migration.html#... (p.s. I'm the author of the post)
    • I_am_tiberius 5y ago
      Thanks a lot for that information!