Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

What are the drawbacks of Citus/why isn't it perfect/what would you look for from a competitor/alternative?


Citus works really well *if* you have your schema well defined and slightly denormalized (meaning you have the shard key materialized on every table), and you ensure you're always joining on that as part of querying. For a lot of existing applications that were not designed with this in mind if can be several months of database and application code changes to get things into shape to work with Citus.

If you're designing from scratch and make it worth with Citus then (specifically for a multi-tenant/SaaS sharded app) it can make scaling seem a bit magical.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: